Team,
Please find attached. I would like to do all the editing in a file like this and be able to have all the fields edited/updated once the employee number (EMPLID#) is found. I know i currently have it set up as a mail merge, but that is not a function in excel. I would only like to use this one file while updating the master sheet periodically. Please advise, and do not be afraid to be innovative with me in getting this done.
|