| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to select all sheets in front of a particular sheet???
Hi,
I have files which the sheets are structured in such a way as below:- 2009 2006 2005 2004 2003 2002 1990 Raw Data Is there any way that I can use macro to select all the sheets placed in front of Raw Data sheet and move it to a new file??? I have tried to record a macro to do so but all the sheet's names are being specified in the code which made the macro not flexible; cause the sheets may have been named with different years!! Anyone has any solution; please advice.... Thanking in advance!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying data from several sheets to a front sheet | Excel Worksheet Functions | |||
| Using VBA select sll sheets based on Criteria on each sheet. | Excel Discussion (Misc queries) | |||
| Print sheet 1 on front sheet 2 on back of a page | Excel Programming | |||
| In nameing a sheet in Excel it puts a .xls] in front why? | Excel Discussion (Misc queries) | |||
| how do I tell excell 2003 to print sheets back to front? | Excel Discussion (Misc queries) | |||
Threaded Mode
