I’m trying to make an inventory document for 3 office locations. Each location should have their own inventory list that quantities can be updated. I could use some advice on the following:
List item I would like to make the inventory items pull from one master list of items.
List item Generate a report, or a “view of” summarizing the items that need to be ordered for all of the locations in one sheet
Any advice would be greatly appreciated.