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 » Copy worksheets to another workbook
Copy worksheets to another workbook
Resolved · Low Priority · Version Standard
Wed 12 Mar 2008, 09:41Delegate Dimitrios said...
Dimitrios has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Copy worksheets to another workbook
Hello,
I am trying to copy worksheets from 5 different spreadsheets. The worksheets that need to be copied should contain the word "IFIP" within the worksheet tab name. After the macro finds the tabs matching IFIP, then i want to copy these workbooks to another spreadsheet that i have created.
I have tried to do a For Each function but no joy.
Can you please help me out. I would greatly appreciate your quick response since this needs to be done by today.
Best regards,
Dimitrios
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:Random NumbersType =RAND()*200 to generate a number between 1 and 200. |
