maybe im doing something wrong or my question was not explained properly. 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.

"Gord Dibben" wrote:

=INDIRECT("ws" & (ROW()) & "!$H$6")

Substitute for "ws" if not "ws" per your example.

Entered in a cell in row 1 and copied down that column


Gord Dibben MS Excel MVP

On Mon, 26 Jun 2006 08:56:03 -0700, barry
wrote:

i have created a log on worksheet 1 that references cell h6 on ws2,
ws3,ws4...... and i want to be able to fill down in a series but the fill
handle only fills down the same worksheet so i have type the ws# each time.
how can i fill down easily