D
doug5jmp
I have created an inventory excel setup whereas we have:
Central server for storing data and each location saves the files to the
same server
There is my computer that I will pull reports to.
There are 5 locations entering current inventory (each with a wkbk)
I than have a separate sheet for the backstock req'd for each inventory item
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
I than have a delivery made wkbk linked to current inventory and inventory
needed for each location
When deliveries are made to each location the delivery worksheet is filled
and saved:
Each location current inventory and inventory needed wkbks update
Than the (warehouse) where the inventory is removed which is linked to the
delivery wksheet...will reduce its current inventory
Which I offset current inventory of the warehouse with its own deliveries.
I reconcile inventory once a month on a separate wksheet as +/- current
supplies...which updates the warehouse currently inventory
The inventory list in column A --> "item List" heading is in A4 and the
inventory items are listed below.
All locations have the same inventory item list with the same style in each
of the worksheets/workbooks.
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.
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.
Introduction over:
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.
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.
I would like to be able to see each date/column and Have a sum column for a
running total.
I believe I can use the dates and create date range in creating my reports.
I have office 2003 on my work computer though I have 2007 at home if need be.
I have been searching endlessly to find what I need!
I can use other programs if instructed on how to...
Programs at work: Office-Access, Excel, Infopath, word, powerpoint ALL 2003
Programs at home: Office- Access, Excel, Groove, Infopath, OneNote, Outlook,
Powerpoint, project professional, publisher, visio professional, word All
2007
Central server for storing data and each location saves the files to the
same server
There is my computer that I will pull reports to.
There are 5 locations entering current inventory (each with a wkbk)
I than have a separate sheet for the backstock req'd for each inventory item
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
I than have a delivery made wkbk linked to current inventory and inventory
needed for each location
When deliveries are made to each location the delivery worksheet is filled
and saved:
Each location current inventory and inventory needed wkbks update
Than the (warehouse) where the inventory is removed which is linked to the
delivery wksheet...will reduce its current inventory
Which I offset current inventory of the warehouse with its own deliveries.
I reconcile inventory once a month on a separate wksheet as +/- current
supplies...which updates the warehouse currently inventory
The inventory list in column A --> "item List" heading is in A4 and the
inventory items are listed below.
All locations have the same inventory item list with the same style in each
of the worksheets/workbooks.
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.
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.
Introduction over:
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.
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.
I would like to be able to see each date/column and Have a sum column for a
running total.
I believe I can use the dates and create date range in creating my reports.
I have office 2003 on my work computer though I have 2007 at home if need be.
I have been searching endlessly to find what I need!
I can use other programs if instructed on how to...
Programs at work: Office-Access, Excel, Infopath, word, powerpoint ALL 2003
Programs at home: Office- Access, Excel, Groove, Infopath, OneNote, Outlook,
Powerpoint, project professional, publisher, visio professional, word All
2007