Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Consolidate
Hello. I have a workbook that has 50+ sheets, all the same format. Is
there a way I can consolidate the data on all sheets into 1? Basically if I were to do it manually, I would simply copy the data form one sheet, and paste it under the others. No math or summing, etc. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Consolidate
Try this Steph
http://www.rondebruin.nl/copy2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Steph" wrote in message ... Hello. I have a workbook that has 50+ sheets, all the same format. Is there a way I can consolidate the data on all sheets into 1? Basically if I were to do it manually, I would simply copy the data form one sheet, and paste it under the others. No math or summing, etc. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidate | Excel Discussion (Misc queries) | |||
Consolidate | Excel Discussion (Misc queries) | |||
consolidate | Excel Discussion (Misc queries) | |||
Consolidate | Excel Discussion (Misc queries) | |||
Consolidate | Excel Programming |