Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel vba (macro)
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel vba (macro)
Resolved · Medium Priority · Version 2003
Reply Thu 18 Jun 2009, 16:51Delegate 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?
For upcoming training course dates see: Pricing & availability
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
Reply Tue 30 Jun 2009, 22:58Delegate 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
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.
|