mock reg list.png
I have a list of workers who rang on different registers on any given day (Register list example). I need to use that table to populate a list on another worksheet (Cash register worked list example).
I then need to have the worked list highlight the cells of the registers they have worked that day.
I can not figure out how to make the second part to populate, then get rid of duplicates and then use that info to either highlight or not highlight based on registers worked.
ANY help would be very appreciated!!
Bookmarks