Good evening, new to excel and forum.
I'm managing a spread sheet with 360ish individuals info on with C.40 data points per person. I have a master list with all the information and regularly have deploy teams from the master list (named nominal roll). In the past I've just been copy and pasting the relevant info. This takes alot of time, and is mind numbing.
Each person is identified by a staff number in column A on the master sheet. Is there a way to input an individuals staff number in column A on one of the teams sheets and to copy all the data points from the master(its all sheets are all set up in the same same order so should copy across directly)
Thanks in advance,
Bookmarks