Copy worksheets to another workbook

The UK's most regular instructor-led training courses.
Training information: excel course · Excel training courses · VBA courses London

· Low Priority · Version Standard

Dimitrios has attended:
Excel Advanced course
Excel VBA course

by - delegate Dimitrios [4 posts] (2008 Mar 12 Wed, 09:41) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 9 Wed	Bloomsbury	0	FULL
2003/XP	2008 Jul 9 Wed	Bayswater	2	book now	£195	£205
2003/XP	2008 Jul 16 Wed	Tooting	0	FULL
2003/XP	2008 Jul 16 Wed	Bloomsbury	1	book now	£235	£240
2003/XP	2008 Jul 18 Fri	Southwark	4	book now	£224	£235
2003/XP	2008 Jul 23 Wed	Southwark	0	FULL
Full Schedule: See all 143 Excel Advanced course dates. Bookings currently available until 24th November 2009.

· Microsoft Office and the Small Business: Part 1 Excel
· Excel Macros for the Non-Programmer
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Tap the Power of Recorded Macros with MS Excel Courses
· Microsoft Excel Features and Functions for Accountants

Please browse our web site to find out more about
excel course and other Microsoft training courses.

Excel tip:

Change Excel's default font

You can change the default font and font size for all spreadsheets created in Excel by:

1. Going to Tools on the menu bar.
2. Select Options, then General.
3. Next to Standard Font you can change the font and font size.
4. Click OK.

Each new file you start from this point onward should use the font and font size you have selected.

View all Excel hints and tips