insert rows and update linked cells
 

I have a master worksheet with 25 other worksheets linked to it. Is there a
way for me to add rows throughout the master and have the linked worksheets
add the same rows and then update the information added to the Master
worksheet? I have owners with an owner number and need to be able to
additional owners under them in case of a sale or death. Thank you for any
help.

Hi Laura

Click on the first sheet tab, then whilst holding doen the shift button,
click on the last. This will Group the sheets.
Now anything you do to one sheet, will be replicated to all the sheets in
the group.
Insert your rows, copy any formula you need into the new rows.
Click on any individual sheet tab to ungroup them again.

--
Regards

Roger Govier


"Laura" wrote in message
...
I have a master worksheet with 25 other worksheets linked to it. Is there
a
way for me to add rows throughout the master and have the linked
worksheets
add the same rows and then update the information added to the Master
worksheet? I have owners with an owner number and need to be able to
additional owners under them in case of a sale or death. Thank you for
any
help.

Wow! Thanks Roger! You made it work. I will be gold for the afternoon.

Laura

"Roger Govier" wrote:

Hi Laura

Click on the first sheet tab, then whilst holding doen the shift button,
click on the last. This will Group the sheets.
Now anything you do to one sheet, will be replicated to all the sheets in
the group.
Insert your rows, copy any formula you need into the new rows.
Click on any individual sheet tab to ungroup them again.

--
Regards

Roger Govier


"Laura" wrote in message
...
I have a master worksheet with 25 other worksheets linked to it. Is there
a
way for me to add rows throughout the master and have the linked
worksheets
add the same rows and then update the information added to the Master
worksheet? I have owners with an owner number and need to be able to
additional owners under them in case of a sale or death. Thank you for
any
help.