adding the qty's of products from several worksheets.

S

Steve

I have a summary sheet with all my products listed and in 15 other sheets I
have a blank purchase order with a quanties column and a product column. As I
fill out the P.O.'s in all 15 sheets with amounts of a certain product I need
to find that product in the columns from all the tabs and sum the amounts to
my summary sheet. Can this be done?
Summary Sheet
A1 is product item
B1 in the total amount ordered from P.O.
A2 is a different product item
B2 is the total from P.O.
so on and so on for all products

P.O. sheets
A1 is the amount ordered
B1 is a product from any of the items from my product list
this P.O. sheet has about 15 rows in it.
 
S

Steve

I failed to mention that in my summary sheet I have a total quanity for
inventory and that I subtract my amounts from the P.O. totals to come up with
a balance of what I have on hand and I am not sure if I can make the piviot
table work for me in this way.
 
R

ryguy7272

Personally, I would do it this way.

1) Merge data from all sheets onto one single summary sheet:
http://www.rondebruin.nl/copy2.htm

2) Build a Pivot Table, based on your specific criteria.

3) If you want to do additional analytics, copy/paste this Pivot Table into
another sheet; make sure you use Copy > Paste Special > Values.

Hope that helps.
Ryan---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top