JimS
07-15-2009, 12:46 PM
I need to create a Table on a Totals Sheet that captures Row 1, 2 & 3 information for each column, from several Source Sheets in the same workbook.
Each Source Sheet could have several "sets" of data points that need to be copied in to the Table in a certain order.
Each Source Sheet’s name begins with the name "Sheet" (ie: Sheet1, Sheet1 (2), Sheet1 (3), etc). There could be anywhere from 1 to 32 Source Sheets containing data points that need to populate the Totals Table.
The data points do not get populated into the Table in the same order that they are laid out on the Source Sheet though. This might be the most difficult part.
I have included an example file that shows what I’m trying to accomplish.
Thanks for any and all help.
Jim
Each Source Sheet could have several "sets" of data points that need to be copied in to the Table in a certain order.
Each Source Sheet’s name begins with the name "Sheet" (ie: Sheet1, Sheet1 (2), Sheet1 (3), etc). There could be anywhere from 1 to 32 Source Sheets containing data points that need to populate the Totals Table.
The data points do not get populated into the Table in the same order that they are laid out on the Source Sheet though. This might be the most difficult part.
I have included an example file that shows what I’m trying to accomplish.
Thanks for any and all help.
Jim