@jefferybrown

I copied and pasted the code you provided in the VBA editor it doesn't insert a time into cell H2 when I enter a value into A2. Is there something else I need to do?

I have attached the workbook for this formula to make it easier. I would like to show the time into column H that each person entered the complex by the value that is entered in column B.

so as each person enters the gate we can show the time they entered by the pass# assigned to them. I can make the pass# whatever I want except for us the numbers and letters represent a location and guest number so we know their location in the complex.

Thank you,

Attached Files

TI_Res_info.xlsx (95.7 KB, 10 views)