I have a badge inventory as attached. I will need assistance of requiring a formula when the serial number of the badge is scanned in tab 1 (Scan) in cell A2, the formula does a search and indicates a check mark on the current date on the badge number in tab2 (Guest).
Not sure if a VBA formula will work well with my objective of excel formula in the cells will do. Please advice.
Any help will be greatly appreciated.
Bookmarks