.. How can I make the row change
in worksheet 1, column A,
replicate as a (corresponding)
row change in all the other worksheets?

Formulas cannot achieve the essence above, Bob.
We would need a subroutine (vba) to do that.
(I did a brief trawl through google's archives
but was unable to find something suitable to suggest)

Hang around awhile for possible responses from others versed in vba who
might have something to offer you.
(I've cross posted this response to .programming)

Good luck !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"BobW" wrote in message
...
Max, the formula you gave, to "copy down", works great
except that when I add or delete a row to worksheet 1,
column A, it only adds or deletes one CELL in
the Column A's of all the other worksheets...
resulting in data misalignment
with the rest of the columns on those sheets.
How can I make the row change
in worksheet 1, column A, replicate as a row change
in all the other worksheets? (Note: Worksheet 1's
columns b through ?? have different data
layout content and requirements than columns b
through ?? on the other worksheets.)
I also forwarded this to you via email with examples.