Hello. Please forgive me being a novice.
I have a spreadsheet where sheet 1 is a master list of staff names and their current posting. The columns to the right of this contain details of planned or completed training. The list of names also serves as a master list of staff posted to my area.
I need to create 2 more sheets which have the names list from sheet 1 with the columns to the right showing different data about them. I want sheet 1 to be the master list of names which is the only one that is edited.
I have created the sheets and used the simple formula =('sheet1'!A1) which works fine - the list of names is there and changes across the sheets when changed on sheet 1. My problem is, when a new row (for a new member of staff's arrival) is added to sheet 1, it does not insert a new row in the other 2 sheets. Likewise when a row is deleted from sheet 1 it remains on the others. The formula still remains correct but the new name isn't on sheets 2 and 3. I know about grouping sheets from the tabs however once another none-grouped tab is selected, the grouping stops. The team that will be using this are not computer literate and therefor telling them to group sheets before adding a row is not an option.
Is there a way of making all changes (both changes to names and new rows inserted / old rows deleted) to sheet 1 happen across sheets 2 and 3 in real time? I've played with macros after looking on other posts and they are way above my level.
Thank you in advance
Bookmarks