Inserting Rows into multiple worksheets

[Andrew]

I have a number of linked worksheets & would like to know if its possible &
how, to insert a row into one sheet it will auotmatically insert a row into
the corresponding linked sheet with the same formatting. Ideally it might
also allow for automatically updating the numbering (in the 1st column)
similar to when inserting number bullets in word.

Any suggestions & help appreciated

 

[bman]

Are you talking about separate files or multiple worksheets in the same file?
If it's the latter, If you hold down the shift or control key and click on
the tab for each worksheet you want to activate, then when you insert rows,
or add data to your main sheet, each sheet that has been selected will be
updated accordingly. I don't know if this meets your definition of
automatic. Search for "select on or multiple worksheets in help. I don't
believe this can be accomplished in separate files and I haven't tried it.

 

[Andrew]

Thanks, that works however I now realize that where i want to input the data
is on a different row number in each sheet ie; sheet 1 row 50, links to sheet
2 row 234 so if i insert above row 50 on 1st sheet i would like to
automaticaly insert a row above row 234 on second sheet.
As i said before it would be really good if it updated the sequental
numbering in the 1st column and maintained the formatting. I could
name/define the range if that was advantageous.
Any help appreciated?????