I'm now in charge of our envelope inventory. It's spread out in a number of locations in the warehouse. I've given the locations unique labels and there are unique labels for each type of envelope as well.
I have an spreadsheet with a row for each location then I enter what type of envelope is in the location and the quantity.
What I'm looking for is a way to call up the data by the description label and easily total what quantities I have of that particular type of envelope from the various locations.
Spread sheet headers look like this:
Location Client Description Qty Inventory Date
I have Excel 2007 and Access 2003 to work with. This is pretty simple, but I just can't see the solution.
I would create a dynamic named range for your data and pivot table it. I assume the columns will stay the same so something like this create a named range with something like this =offset(A1,0,0,counta(A1:A65000),5)