Excel vba (macro)

Resolved · Medium Priority · Version 2003

Thu 18 Jun 2009, 16:51 Delegate Rohit said...

Rohit has attended:
Excel VBA Intro Intermediate course

Excel vba (macro)

i have a worksheet with multiple directorates and information under each directorates.
how can i automate the worksheet to select split the worksheets at different directorates and save them as seperate files under the directorate name?

Mon 22 Jun 2009, 11:37 Trainer Carlos said...

RE: excel vba (macro)

Hi Rohit

Could you clarify this question for me?

1. What is a directorate?

2. How does the above information appear on the worksheet?

3. Do you mean to separate them into worksheets in the same workbook or separate workbooks?

Regards

Carlos

Tue 30 Jun 2009, 22:58 Delegate Rohit said...

RE: excel vba (macro)

hi carlos
thank you for replying.
i have managed to split the worksheet into seperate worksheets.

the only problem i now have is, how do i select department names from a column which has the same department names repeated many times, and then copy those names into seperate sheets?

i hope that makes sense.

regards

rik

Tue 24 Nov 2009, 09:45 Trainer Stephen said...

RE: excel vba (macro)

Hi Rohit

First let me apologise for our failure to follow up this post. Carlos allocated it to me to have a look at and I'm afraid I missed it.

If this is still a live issue for you perhaps you could send me a sample spreadsheet so I can investigate and give the matter urgent attention

Regards

Stephen

Mon 30 Nov 2009: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips