Creating Inventory reports

doug5jmp

Board Regular
Joined
Apr 27, 2010
Messages
62
I have created an inventory excel setup whereas we have:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
<o:p> </o:p>
Central server for storing data and each location saves the files to the same server<o:p></o:p>
<o:p> </o:p>
There is my computer that I will pull reports to.<o:p></o:p>
There are 5 locations entering current inventory (each with a wkbk)<o:p></o:p>
I than have a separate sheet for the backstock req'd for each inventory item<o:p></o:p>
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:p></o:p>
I than have a delivery made wkbk linked to current inventory and inventory needed for each location<o:p></o:p>
When deliveries are made to each location the delivery worksheet is filled and saved:<o:p></o:p>
Each location current inventory and inventory needed wkbks update<o:p></o:p>
<o:p> </o:p>
Than the (warehouse) where the inventory is removed which is linked to the delivery wksheet...will reduce its current inventory<o:p></o:p>
Which I offset current inventory of the warehouse with its own deliveries.<o:p></o:p>
I reconcile inventory once a month on a separate wksheet as +/- current supplies...which updates the warehouse currently inventory<o:p></o:p>
<o:p> </o:p>
The inventory list in column A --> "item List" heading is in A4 and the inventory items are listed below. <o:p></o:p>
All locations have the same inventory item list with the same style in each of the worksheets/workbooks. <o:p></o:p>
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:p></o:p>
<o:p> </o:p>
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:p></o:p>
<o:p> </o:p>
Introduction over: <o:p></o:p>
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:p></o:p>
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:p></o:p>
I would like to be able to see each date/column and Have a sum column for a running total.<o:p></o:p>
I believe I can use the dates and create date range in creating my reports.<o:p></o:p>
I have office 2003 on my work computer though I have 2007 at home if need be.<o:p></o:p>
<o:p> </o:p>
I have been searching endlessly to find what I need!<o:p></o:p>
 

doug5jmp

Board Regular
Joined
Apr 27, 2010
Messages
62
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 <!-- / message --><!-- edit note -->
 

doug5jmp

Board Regular
Joined
Apr 27, 2010
Messages
62
I have not found software that can take my excel files are place them into said program directly as a database.
 

Colby

Board Regular
Joined
Feb 19, 2008
Messages
86
Download Excel 2010 Beta and the PowerPivot install. you should be able to do everything you want with that.
 

doug5jmp

Board Regular
Joined
Apr 27, 2010
Messages
62
Why is it called beta and how long can I use it for?
I have a 32 bit operating system thus I need powerpivot 32bit?
 

Forum statistics

Threads
1,082,478
Messages
5,365,792
Members
400,852
Latest member
katedun

Some videos you may like

This Week's Hot Topics

Top