Hi
I could use some VBA help on an inventory received workbook I am working on. I have input some samples in yellow for expected results.
On the "Enter here" Tab, I have highlight the cells in green which require manual input.
Cell B5 and C5 - Date range to search from
Report number - There are 2 tabs with identical column headers
Scan ID - to look up Column C "Unique number" in Table tab
Quantity - To indicate Quantity received
The code that i need help on is on each report tab, i would need columns I to indicate the word “fully received” if the quantity is received in full and “partial” if received not in full quantity.
In column J to input the data of the quantity received from the "enter here" tab.
For Example: info input on the "enter here" tab
Date range - 18 may 18 to 21 may 18 (To look up the date on report tab on column C within this range)
Report number – Report 1 (To look up Date/Scan ID in report 1 tab)
Scan ID – 123456 (To look up 123456 Column C "Unique number" in Table tab which is Banana and find for the value (banana) on report tab 1
Quantity – 10 (to input 10 in column J)
If any of the data on the “Enter here” tab does not match the error message “Item not found” will be prompted
Hope to get some help. Thank you in advance.
Bookmarks