C
CAM
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
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