Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
consolidating workbooks into one workbook
Hello,
I have 30 workbooks containing one worksheet all of the worksheet has the same name "sheet1". What I want to do is to somehow get all the infomation from the worksheets from all of the workbooks into a new workbook into one worksheet sheet1". All of the workbooks are in the same folder called "c:\Test" and all of them have headers from rows1 to 5. What I want is to pick the information starting from row 6 and on. Rows will vary. How do I do this? I am using Excel 2003. Thank you in advance. Cheers |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
consolidating workbooks into one workbook
Start here
http://www.rondebruin.nl/copy3.htm Try the add-in -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "CAM" wrote in message ... Hello, I have 30 workbooks containing one worksheet all of the worksheet has the same name "sheet1". What I want to do is to somehow get all the infomation from the worksheets from all of the workbooks into a new workbook into one worksheet sheet1". All of the workbooks are in the same folder called "c:\Test" and all of them have headers from rows1 to 5. What I want is to pick the information starting from row 6 and on. Rows will vary. How do I do this? I am using Excel 2003. Thank you in advance. Cheers |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
consolidating workbooks into one workbook
Thanks Ron I appreciated your help.
"Ron de Bruin" wrote in message ... Start here http://www.rondebruin.nl/copy3.htm Try the add-in -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "CAM" wrote in message ... Hello, I have 30 workbooks containing one worksheet all of the worksheet has the same name "sheet1". What I want to do is to somehow get all the infomation from the worksheets from all of the workbooks into a new workbook into one worksheet sheet1". All of the workbooks are in the same folder called "c:\Test" and all of them have headers from rows1 to 5. What I want is to pick the information starting from row 6 and on. Rows will vary. How do I do this? I am using Excel 2003. Thank you in advance. Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
consolidating workbooks(not sheets) | Excel Programming | |||
Consolidating from Several Workbooks | Excel Worksheet Functions | |||
consolidating workbooks | Excel Worksheet Functions | |||
Consolidating multiple workbooks | Excel Worksheet Functions | |||
Consolidating data from different workbooks | Excel Worksheet Functions |