bobsburgers
Board Regular
- Joined
- Jun 25, 2017
- Messages
- 60
Hi, all -
I have an inventory interface we use to track items that have left our store location without payment.
We would like to make the interface more detailed, so we have uploaded our Master SKU List into the same Excel workbook (this includes inventory levels, item description, etc.).
Ideally, when we scan an item into the tracking interface, Excel would be able to extract the data from the Master SKU List and automatically fill in cells with information such as the inventory levels and item descriptions.
I'm not sure if a pivot table would be appropriate or perhaps a Macro - any advice would be greatly appreciated!
Thank you everyone!
Best,
Bob
I have an inventory interface we use to track items that have left our store location without payment.
We would like to make the interface more detailed, so we have uploaded our Master SKU List into the same Excel workbook (this includes inventory levels, item description, etc.).
Ideally, when we scan an item into the tracking interface, Excel would be able to extract the data from the Master SKU List and automatically fill in cells with information such as the inventory levels and item descriptions.
I'm not sure if a pivot table would be appropriate or perhaps a Macro - any advice would be greatly appreciated!
Thank you everyone!
Best,
Bob