Creating a log in a workbook
 

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.

Creating a log in a workbook
 

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.