C
Connie
I have a summary worksheet at the end of 12 other sheets,
each sheet being the figures for the month. On the
summary sheet I have, for instance, "Average Transit Time"
as a row heading, and then JAN, FEB, MAR....DEC" as column
headings. In JAN, the simple formula is ='JAN 2004'!H2.
Now I would like to drag that to the end of the year, but
it gives, of course, ='JAN 2004'!I2, ='JAN 2004'!J2, etc.
How do I drag it to get ='FEB 2004'!H2, ='MAR 2004'!H2. I
want it to pick up the same cell on each worksheet, not
consecutive cells within the same worksheet. Hope I'm
explaining myself clearly.
Thank you
Connie
each sheet being the figures for the month. On the
summary sheet I have, for instance, "Average Transit Time"
as a row heading, and then JAN, FEB, MAR....DEC" as column
headings. In JAN, the simple formula is ='JAN 2004'!H2.
Now I would like to drag that to the end of the year, but
it gives, of course, ='JAN 2004'!I2, ='JAN 2004'!J2, etc.
How do I drag it to get ='FEB 2004'!H2, ='MAR 2004'!H2. I
want it to pick up the same cell on each worksheet, not
consecutive cells within the same worksheet. Hope I'm
explaining myself clearly.
Thank you
Connie