I have a workbook with sheet 1 thru sheet 31, sheets 1 thru 30 are formatted
identical except that there are different values in the cells, ie cell a1 on
sheet 1 the value is contractor A, sheet 2 cell a1 the value is contractor B.
what i would like to do is have sheet 31 be a log so that i can see at a
glance what is on sheet 1 thru sheet 30 cel a1. so i copied cell a1 on sheet
1 and pasted it to sheet 31 and linked the cells, i then filled down but had
to change the sheet # in each cell because it picked up sheet 1 all the way
down the fill. how can i accomplish this without having to type in every
cell.

Barry

Stay with the same thread.

Same answer to this post as to your other posts.

Use the INDIRECT function.


Gord Dibben MS Excel MVP


On Wed, 5 Jul 2006 09:59:01 -0700, barry
wrote:

I have a workbook with sheet 1 thru sheet 31, sheets 1 thru 30 are formatted
identical except that there are different values in the cells, ie cell a1 on
sheet 1 the value is contractor A, sheet 2 cell a1 the value is contractor B.
what i would like to do is have sheet 31 be a log so that i can see at a
glance what is on sheet 1 thru sheet 30 cel a1. so i copied cell a1 on sheet
1 and pasted it to sheet 31 and linked the cells, i then filled down but had
to change the sheet # in each cell because it picked up sheet 1 all the way
down the fill. how can i accomplish this without having to type in every
cell.