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?
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
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
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
