Integrate two Tables from different worksheets

bobsburgers

Board Regular
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
 

Some videos you may like

This Week's Hot Topics

Top