I have a spreadsheet that contains yearly data for entries into a contest. The entries are based on employees number, and maintains an updated count of entries.
I receive a new spreadsheet monthly, that updates totals for each employee. However, this new spreadsheet also contains new employees that aren't in the current list. Both lists are very large, so I would like to figure out a way to automatically update the totals for each employee, as well as automatically add new employees. Is there any way to do this?
Bookmarks