Then the first step would be, to make sure that all names in all sheets are the same.
1) Maybe you can change this source?This source doesn't show full names (leaves out middle initials).
2) If not than don't work with the source and make a link to the sheet with the names (file B) in it.
After that make sure you validate the input.
This can be done with Data => datavalidation.
3) Why are there so many differant files anyway (1 for each day) / 1 for each employee)?
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
The other sources are not mine. The only thing I can change is how Spreadsheet A works. Do you have any suggestions on how to get the index/match to work?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks