Who inputs the names in table 1 in spreadsheet A in the file?
That is where you get the trouble?
With a pivot table you won't have that problem, since it will that the names of sheet back up.
If those names are writting correct, that will also solve your problem.
See the attached file, where I add a pivot table.
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.
Thanks for your efforts, but that's not really what I'm looking for. It just adds another table that would have to be updated throughout all my many files. Wouldn't I would have to copy all the names (hundreds) from Spreadsheet B into the pivot table every time I use the file to make sure the pivot table list is up to date? Spreadsheet B is not a static file; it's being updated all the time. Plus, I don't need all that data inside each file. I'm usually using less than 20 names out of the hundreds available. The problem comes in when I receive which names I need to use, they aren't the entire name (ex: no middle initials). And while I could look up and enter the entire name, I don't want to use the entire name for the reports based off this information (Table 1) so I was trying to skip that manual step.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks