J
John13
I have an inventory spreadsheet with 125 tabs. The tabs are numbered
1 through 125. The are identical except for the data below the column
headings. If I wanted to put a formula in H5 on every tab, can it be
done other than manually opening every tab and typing it?
One additional question: If I add a Summary Tab, how could I show the
value of a specific cell on each tab without manually entering it? I
show the formula I'm using bring B3 to the summary for every tab:
A B
1 Unit Value
2 1 ='1'!B3
3 2 ='2'!B3
4 3 ='3'!B3
5 4 ='4'!B3
6 5 ='5'!B3
7 6 ='6'!B3
8 7 ='7'!B3
9 8 ='8'!B3
But to do it 125 times is a killer, besides I want to bring other
specific cells over to the summary also. I was thinking of
CONCATENATE if all else fails. Help please! Thanking you ahead of
time.
John
1 through 125. The are identical except for the data below the column
headings. If I wanted to put a formula in H5 on every tab, can it be
done other than manually opening every tab and typing it?
One additional question: If I add a Summary Tab, how could I show the
value of a specific cell on each tab without manually entering it? I
show the formula I'm using bring B3 to the summary for every tab:
A B
1 Unit Value
2 1 ='1'!B3
3 2 ='2'!B3
4 3 ='3'!B3
5 4 ='4'!B3
6 5 ='5'!B3
7 6 ='6'!B3
8 7 ='7'!B3
9 8 ='8'!B3
But to do it 125 times is a killer, besides I want to bring other
specific cells over to the summary also. I was thinking of
CONCATENATE if all else fails. Help please! Thanking you ahead of
time.
John