+ Reply to Thread
Results 1 to 2 of 2

Insert/remove rows on sheet one and have it reflect on all sheets

  1. #1
    Registered User
    Join Date
    03-27-2013
    Location
    CA, USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Insert/remove rows on sheet one and have it reflect on all sheets

    I am keeping track of events personnel complete. I have 40 tabs, one for each event and if I have someone to add/remove I have to go to each sheet and add/remove them for each event. I would like to be able to accomplish this via sheet one if possible. So I would like to insert/remove rows on sheet one and have it reflect on all other sheets.

    Also I would like to know how to get the first three columns on the first sheet to be put onto all other sheets in the workbook. I would like to not have to go to each sheet and set the cells equal to sheet one cells since I have about 40 sheets and around 100 rows.

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,670

    Re: Insert/remove rows on sheet one and have it reflect on all sheets

    Select all sheets and if you make a change at one they all change in the same way
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1