Badge Inventory look up

Hi need some help on an excel badge scanning file. I have a column of badge numbers which will get the date time stamped when I key in the badge number in tab 1 onto the table in tab 2. What I need help on is when I place a list of names (Permanently issued cards) in a table on tab 3. The names get automatically ported over to tab 2 for that date. The table should be expandable so that I can add and remove names whenever needed.

Hi,

I made a new tab, where you get the names. It seems to be the simplest way of solving it. What it does is looking up the name of the person, if there is a register of a badge scan for the day.

The formula simply checks if there is anything in the cell that corresponds to the day and person in the timestamps tab and, if so, looks up the name of the badge's owner.

Please Login or Register  to view this content.

This makes it easier for further analyses, because in one sheet you keep the timestamps and in the other table, you get the lists with the names. It is also possible to then simply concatenate the information of the two tables, but I would not change anything in your the timestamps tab.

This way, you don't need further macros. I hope it solves your problem.

Best regards,

Francisco