I have created an inventory excel setup whereas we have:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o> </o>
Central server for storing data and each location saves the files to the same server<o></o>
<o> </o>
There is my computer that I will pull reports to.<o></o>
There are 5 locations entering current inventory (each with a wkbk)<o></o>
I than have a separate sheet for the backstock req'd for each inventory item<o></o>
I than a workbk that when all areas are saved will subtract needed backstock and current inventory and give the inventory needed for each location on a single page<o></o>
I than have a delivery made wkbk linked to current inventory and inventory needed for each location<o></o>
When deliveries are made to each location the delivery worksheet is filled and saved:<o></o>
Each location current inventory and inventory needed wkbks update<o></o>
<o> </o>
Than the (warehouse) where the inventory is removed which is linked to the delivery wksheet...will reduce its current inventory<o></o>
Which I offset current inventory of the warehouse with its own deliveries.<o></o>
I reconcile inventory once a month on a separate wksheet as +/- current supplies...which updates the warehouse currently inventory<o></o>
<o> </o>
The inventory list in column A --> "item List" heading is in A4 and the inventory items are listed below. <o></o>
All locations have the same inventory item list with the same style in each of the worksheets/workbooks. <o></o>
The dates than are listed in Row 4 with the (for example) current supplies entered by each location entered below the date, in the column.<o></o>
<o> </o>
At this point I have all my count if's etc. working and the list of 19 wksheets that are linked auto populate correctly when information is entered.<o></o>
<o> </o>
Introduction over: <o></o>
My First Problem is creating one location that will pull a report of all the information into one central wksheet where I can than create tables and graphs as in a pivot table.<o></o>
My Second Problem is being able to update the central wksheet when new dates are added into each location (New columns added which are currently empty) as they report in the future. <o></o>
I would like to be able to see each date/column and Have a sum column for a running total.<o></o>
I believe I can use the dates and create date range in creating my reports.<o></o>
I have office 2003 on my work computer though I have 2007 at home if need be.<o></o>
<o> </o>
I have been searching endlessly to find what I need!<o></o>
fficeffice" /><o></o><o
> </o>Central server for storing data and each location saves the files to the same server<o
></o><o
> </o>There is my computer that I will pull reports to.<o
></o>There are 5 locations entering current inventory (each with a wkbk)<o
></o>I than have a separate sheet for the backstock req'd for each inventory item<o
></o>I than a workbk that when all areas are saved will subtract needed backstock and current inventory and give the inventory needed for each location on a single page<o
></o>I than have a delivery made wkbk linked to current inventory and inventory needed for each location<o
></o>When deliveries are made to each location the delivery worksheet is filled and saved:<o
></o>Each location current inventory and inventory needed wkbks update<o
></o><o
> </o>Than the (warehouse) where the inventory is removed which is linked to the delivery wksheet...will reduce its current inventory<o
></o>Which I offset current inventory of the warehouse with its own deliveries.<o
></o>I reconcile inventory once a month on a separate wksheet as +/- current supplies...which updates the warehouse currently inventory<o
></o><o
> </o>The inventory list in column A --> "item List" heading is in A4 and the inventory items are listed below. <o
></o>All locations have the same inventory item list with the same style in each of the worksheets/workbooks. <o
></o>The dates than are listed in Row 4 with the (for example) current supplies entered by each location entered below the date, in the column.<o
></o><o
> </o>At this point I have all my count if's etc. working and the list of 19 wksheets that are linked auto populate correctly when information is entered.<o
></o><o
> </o>Introduction over: <o
></o>My First Problem is creating one location that will pull a report of all the information into one central wksheet where I can than create tables and graphs as in a pivot table.<o
></o>My Second Problem is being able to update the central wksheet when new dates are added into each location (New columns added which are currently empty) as they report in the future. <o
></o>I would like to be able to see each date/column and Have a sum column for a running total.<o
></o>I believe I can use the dates and create date range in creating my reports.<o
></o>I have office 2003 on my work computer though I have 2007 at home if need be.<o
></o><o
> </o>I have been searching endlessly to find what I need!<o
></o>
