deborialus
New Member
- Joined
- Sep 6, 2006
- Messages
- 9
I have 5 workbooks named
"stat sheet 2006 Team 1",
"stat sheet 2006 Team 2", etc.
that contain spreadsheets named
1_CE1.xls,
1_CE2.xls,
1_SR CE.xls,
TEAM 1 STATS 2006.xls
and in each spreadsheet are worksheets called 1-CE1 TLS, 1-CE2 TLS, 1-SR CE TLS
where the 1 changes for each team 2 thru 5. I want to subtotal all 1-CE1 TLS.xls, 2-CE1 TLS.xls, 3-CE1 TLS.xls worksheets from the different spreadsheets and create 5 more spreadsheets named All TEAMS CE1, All TEAMS CE2, etc. I use one master spreadsheet for all. So cell B4 is the same across all spreadsheets. What would be the best way? An array of spreadsheets? Something like that? THANKS in advance.
"stat sheet 2006 Team 1",
"stat sheet 2006 Team 2", etc.
that contain spreadsheets named
1_CE1.xls,
1_CE2.xls,
1_SR CE.xls,
TEAM 1 STATS 2006.xls
and in each spreadsheet are worksheets called 1-CE1 TLS, 1-CE2 TLS, 1-SR CE TLS
where the 1 changes for each team 2 thru 5. I want to subtotal all 1-CE1 TLS.xls, 2-CE1 TLS.xls, 3-CE1 TLS.xls worksheets from the different spreadsheets and create 5 more spreadsheets named All TEAMS CE1, All TEAMS CE2, etc. I use one master spreadsheet for all. So cell B4 is the same across all spreadsheets. What would be the best way? An array of spreadsheets? Something like that? THANKS in advance.