insert rows and update linked cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stop linked cells from changing when insert new row? 1
Tie additional cells to cell automatically updated 1
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
links not correct 2
Insert row in Master worksheet that auto inserts in other workshee 2
inserting rows in linked worksheets 1
Move select data to another worksheet 3
Sorting in multiple worksheets 1

Back
Top