Hello,
For Excel 2010:
I've had to create a new workbook where I had to copy and paste the data from 27 other workbooks into this new workbook. There has to be a better way!
The data from the 27 other workbooks all come from 4th tab (sheet) that includes the phrase 'Leading Indicators' (it may have other words). The data always starts on the 5th row (but has a title on the 1st row, followed by a blank row on the 2nd row, with headers on the 3rd row, with more headers on the 4th--I don't need this info), is always 6 columns wide, but the number of rows vary.
How do I get the data from these 27 workbooks into one new workbook automatically where the data will be copied and pasted directly underneath each other? Sometimes the last row of data from the 27 workbooks ends with a empty row colored black--I don't know if that is a problem.
**I think it would be wiser to have a solution in case data should be arranged differently at times, e.g., maybe it could start on another row besides the 5th, maybe the 3rd or the 6th, etc., or the data vary with the number of columns, or the 4th tab contains another phrase. I just want to see if there is a flexible solution.**
I would really appreciate any help b/c there has to be a better way to do this. It was too labor intensive.
For Excel 2010:
I've had to create a new workbook where I had to copy and paste the data from 27 other workbooks into this new workbook. There has to be a better way!
The data from the 27 other workbooks all come from 4th tab (sheet) that includes the phrase 'Leading Indicators' (it may have other words). The data always starts on the 5th row (but has a title on the 1st row, followed by a blank row on the 2nd row, with headers on the 3rd row, with more headers on the 4th--I don't need this info), is always 6 columns wide, but the number of rows vary.
How do I get the data from these 27 workbooks into one new workbook automatically where the data will be copied and pasted directly underneath each other? Sometimes the last row of data from the 27 workbooks ends with a empty row colored black--I don't know if that is a problem.
**I think it would be wiser to have a solution in case data should be arranged differently at times, e.g., maybe it could start on another row besides the 5th, maybe the 3rd or the 6th, etc., or the data vary with the number of columns, or the 4th tab contains another phrase. I just want to see if there is a flexible solution.**
I would really appreciate any help b/c there has to be a better way to do this. It was too labor intensive.