Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi There
I need to run one macro for 5 slightly different named spreadsheets. At the moment, as I'm copying pivot tables between two spreadsheets I have a few lines like this: Windows("Extra Triangles - MOT.xls").Activate I have 4 other sheets that I want to use the same Macro on called Extra Triangles - AMO.xls Extra Triangles - INT.xls Extra Triangles - CAR.xls Extra Triangles - ALL.xls Is there a way I can change this line to just activate any spreadsheet that begins with - Extra Triangles? Any help would be greatly appreciated. Thanks in advance Jamie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
search in a sheet and selection? | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |