delete rows from multiple worksheets

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

Guest

If I have multiple worksheets, "emply info", "cost", & "schedule" and all 3
work together, I need to be able to delete or add a row on the "emply info"
sheet and it automatically will delete or add a row to the 2 other sheets?
 
Assuming the sheet are all in the same workbook:

Go to the worksheet tab at the bottom of the screen, right click on any of
the tabs, choose "Select All Sheets"

As long as all sheets remain selected (don't click any other sheets)
anything you do in one sheet will be done in all the sheets.

Don't forget to select just the specific sheet you want to add data to when
you are done making all the changes to the format of all the sheets...
 

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

Back
Top