| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Sheet, Run Macro, Extract data
Hi All.............
If someone would be so kind, I have great need. I have a XL97 workbook with 38 hidden sheets. I would like to open each sheet by name, one by one, run a macro unique to that sheet, (avg time = 2 minutes), and then extract the values in cells B2 and C6 (after the macro has run as the data will change) to a "ReportSheet" in columns A and B, then on to the next sheet, etc etc. Any assistance or direction would be greatly appreciated. TIA Vaya con Dios, Chuck, CABGx3 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to extract data of a selected sheet | Excel Discussion (Misc queries) | |||
| Help me, compare 2 sheet and extract the match data into the new sheet. | Excel Discussion (Misc queries) | |||
| macro to extract info and paste to a new sheet | Excel Programming | |||
| open text file to extract data | Excel Programming | |||
| How to open a zip file and extract its contents in a macro? | Excel Programming | |||
Threaded Mode
