Thanks again for the response. I must be pretty dense, though, because when
rows insert across all of the grouped sheets, they continue to have no
formulas in them, and hence don't carry the stuff from the "master sheet"
forward. Your revision of the formula does carry info forward iin existing
rows, and that's great, but inserted rows on subsequent sheets are still
goiing in totally blank (with no formulas).

Hmm. I'm beginning to think it might just be easier to continue to be the
point person for all revisions to this thing. If I make it look mystical
enough they'll never fire me because no one else will know how to do it. Job
seciurity.

"Max" wrote:

=OFFSET(Sheet1!$A$8,ROW()-1,)

The amendment looks ok to me.

I presume the above is entered into cell A1 in Sheets 2 - 8, and copied down
to A450 as per suggested steps earlier, with sheets grouped? (The formulas
are sensitive to the cells they are in)

If the starting cell is *not* cell A1 in Sheets 2 - 8,
put instead this slight revision in the starting cell:
=OFFSET(Sheet1!$A$8,ROWS($A$1:A1)-1,)
and then copy down by 450 rows as before,
with sheets grouped

Ensure also that calc mode is set to auto.
Check via clicking:
Tools Options Calc tab Auto OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Michael Link" wrote in message
...
Thanks for the fast reply!

Actually, the rows in the master sheet that i want to 'carry over" are
A8:A400. (I forgot that I have a number of hidden rows at the top that
don't
figure in what I need to do.)

I've tried modifying the formula you so nicely gave me like this:

=OFFSET(Sheet1!$A$8,ROW()-1,)

But it just returns a zero value. Am I missing something? I'm not familiar
with OFFSET, so I'm not sure how else to modify it, and the discussion of
the
syntax in the help box is kind of confusing.