98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel vba (macro)
Excel vba (macro)
Resolved · Medium Priority · Version 2003
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?
Mon 22 Jun 2009, 11:37Trainer 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: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
Tue 24 Nov 2009, 09:45Trainer 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 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 tip:Bracketed negative numbersOften Excel users wish to display negative numbers in colour red and bracketed |
