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.
Bookmarks