Hi all, a relative newbie to excel but going to be taking on a lot soon. I have multiple spreadsheets for multiple trainees who will need to complete demands to become accredited.
Spreadsheet 1 contains a customer number, customer name, and a yes or no box if successfully completed. We have 16 of these seperate spreadsheets for each trainee.
Spreadsheet 2 is a 'master spreadsheet' which 'if the yes/no drop down is yes, we would like the member name and member number to copy in to the master sheet thus collating all 16 in one.
Is this possible or am I wasting my time trying :D.
Any help is greatly appreciated.
Spreadsheet 1 contains a customer number, customer name, and a yes or no box if successfully completed. We have 16 of these seperate spreadsheets for each trainee.
Spreadsheet 2 is a 'master spreadsheet' which 'if the yes/no drop down is yes, we would like the member name and member number to copy in to the master sheet thus collating all 16 in one.
Is this possible or am I wasting my time trying :D.
Any help is greatly appreciated.