Lil Stinker
Board Regular
- Joined
- Feb 16, 2022
- Messages
- 151
- Office Version
- 2019
- Platform
- Windows
Need help with VBA to match/search/find values in a range on one sheet with the same values in another range on a second sheet and input data when the match is found.
Sheet1"Receipt" is a form where multiple serial numbers are entered into the Range B10:S90. (Serial numbers are alphanumeric and sometimes start with 0)
Sheet2"Log" is where I have all of the existing serial numbers stored (as text) in Column B.
The task is to loop through every serial number on Sheet1 and match them to Sheet2. Provided there is a match, enter the date found on Sheet1 cell A1 into Column E on Sheet2 of the matching serial number row. If no match, alert user serial number needs to be entered into inventory.
It seems simple enough for an experienced VBA user but I'm not that.
I would appreciate any help you can provide.
Sheet1"Receipt" is a form where multiple serial numbers are entered into the Range B10:S90. (Serial numbers are alphanumeric and sometimes start with 0)
Sheet2"Log" is where I have all of the existing serial numbers stored (as text) in Column B.
The task is to loop through every serial number on Sheet1 and match them to Sheet2. Provided there is a match, enter the date found on Sheet1 cell A1 into Column E on Sheet2 of the matching serial number row. If no match, alert user serial number needs to be entered into inventory.
It seems simple enough for an experienced VBA user but I'm not that.
I would appreciate any help you can provide.