Creating a Multiple Warehouse Inventory Spreadsheets
 

I need help creating a Inventory control spreadsheet with multiple
warehouses. I need to be able to link them together. How or if can this be
done

What kind of information do you need on each and what info do you need on a
linked spreadsheet?

"Alice" wrote in message
...
I need help creating a Inventory control spreadsheet with multiple
warehouses. I need to be able to link them together. How or if can this
be
done

Anything's possible. If I was designing this system, I would start
with 3 linked tables:

Warehouse table:
Warehouse ID (unique)
{other warehouse data such as address?}

Inventory table:
SKU (or some other unique id)
Description {medium sized widgets, etc.}
{other product specific information}

InventoryLocation table:
Warehouse ID
SKU {warehouse ID and SKU combination will be unique)
Quantity
{other info pertinent to item being in a specific warehouse}

Now, various database look up methods (PivotTables, Data query, etc.)
will let you query the data in a variety of different ways.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I need help creating a Inventory control spreadsheet with multiple
warehouses. I need to be able to link them together. How or if can this be
done