How to import data from other sheets?
Hey all. So I am looking to set up 2 sheets for inventory tracking. The first sheet will be a 'database' of SKUs along with item manufacturer names, model numbers, SKUs etc.
I want to use that database sheet to feed my inventory tracking sheet. Ideally what I'd like to set up is:
Item Sheet: select SKU-001
Sheet references database for SKU-001, and fills in the Manufacturer, Item Name, Model #, Item Category, etc.
How would I go about achieving this?
Help Article Resources
Check out the Formula Handbook template!