Hi,

I would like to know the approach to automate one of this requirement on
excel sheet.

1. I have a workbook with sheet1 having my master data column A (ID), Column
B (FirstName), Column C (LastName) with around 500 records.
2. I will be using blank sheet2 of same workbook to enter ID's in column A
using a barcode scanner.
3. Based on the value of sheet2 column A i.e. (ID), I would like to run a
lookup of ID value in sheet1 and populate sheet2 column B and column C with
corresponding values from sheet1 for respective ID. i.e. respective First
Name and Last Name.
4. And then punch a timestamp in sheet2 columnD of same record.

I would like to know what's the best way to achieve this automation using
formula or programming any macro on key press events of sheet2 column A
values.

Thanks,
Khozema

2. I need to populate data in column B and C in my sheet 1 based on the
value in colu