| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
consolidate over 50 sheets by Macro
I have same set of data for 50 runs of a program, each stored in a sheet. so
I have 50 sheets naming sheet1 to sheet50. Column headings are same for all. I have to consolidate them into one sheet. Instead of going over 50 sheets to add them in consolidation window, is it possible to perform it by MAcro to go over 50sheets? -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan consolidate over 50 sheets by Macro |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro for part of W/book sheets | Excel Discussion (Misc queries) | |||
| Macro and hidden sheets | Excel Discussion (Misc queries) | |||
| Closing File Error | Excel Discussion (Misc queries) | |||
| stop macro from flashing sheets | Excel Discussion (Misc queries) | |||
| Macro to link Sheets to main workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
