Excel Database Summary

[coolcarls]

I have a sheet with my "database", sometimes it'll end at column N and others O or P. In the database I'll have several different Item #'s and several duplicates all with different quantities, I would love to have a summary of the total quantity of items received for all the item #'s.
So If I received item # "123PPP" with a quantity of 100 on June 1st and then on June 21st I received the same item number but 250 of them, on the summary page I just need to see the total of these "123PPP"'s that I have received (along with the rest of the items. This database is constantly being added to and subtracted from.
That is a tall order I think (especially with me not so knowelgable in the area).
Well, thanks in advance

 

[xlbo]

Yuo need to 1st look at dynamic range names:

http://www.cpearson.com/excel/named.htm#Dynamic

Then you need to build a pivot table with ITEMS as row field and SUM of quantity as value field

Then, make the datasource for the pivot table, your dynamic range name
HTH
Rgds
~Geoff~