B
BrettOlbrys
File #1 contains about 150 sheets. Each sheet sums the values in
column and puts the result in cell A20 (for all sheets the result i
also in each sheets cell A20).
File #2 is a summary of the 150 sheets in file #.
I have two questions:
1) How do I have the names of each of the 150 sheets automaticall
appear in a column in file #2?
2) For each of the 150 sheets, how do I have each of the results i
the respective cell A20 also appear in a column in file #2?
Thanks,
Bret
column and puts the result in cell A20 (for all sheets the result i
also in each sheets cell A20).
File #2 is a summary of the 150 sheets in file #.
I have two questions:
1) How do I have the names of each of the 150 sheets automaticall
appear in a column in file #2?
2) For each of the 150 sheets, how do I have each of the results i
the respective cell A20 also appear in a column in file #2?
Thanks,
Bret