Hi
I have a huge list with staff numbers in the workbook sheet1 range from column A 3 to a (unknown the maximum). Which data around 1500 named list (just a numeric the staff no I need to validating who when attendance the general meeting in the main hall, who’s when entrance the room must to shown staff badge, So I have a thing if excel can facility with Input Box to entered the staff numbers, than” value “Y” to put in columns “B when both Input & list are matched.
But I not sure that’s can do or not, hope here’s who expert can help me more,
Thanks very much,