Hi all - I have a master page with A1 containing the names of staff members and then 5 columns indicating preference1 .... preference5.
Each preference column will have one 4 digit site code i.e. 8156 entered
I will have 64 worksheets matching all potential 4 digit site codes that could be entered in the preferences columns
SAMPLE - one staff member entering 5 site codes (A1 to A6)
Billy Bloggs - 8124 - 8456 - 8456 - 8123 - 8882
What I am looking for is a way to autocopy the persons name to the appropriate worksheet and into the correct preference column as I enter the 4 digit code against the staff members name on the master sheet.
Sorry if this sounds a bit confused but so am I.
Bookmarks