adding the qty's of products from several worksheets.
 

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.

adding the qty's of products from several worksheets.
 

A Pivot Table should do that for you:
http://peltiertech.com/Excel/Pivots/pivottables.htm
http://www.contextures.com/xlPivot02.html

Regards,
Ryan---

--
RyGuy


"Steve" wrote:

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.

adding the qty's of products from several worksheets.
 

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.

"ryguy7272" wrote:

A Pivot Table should do that for you:
http://peltiertech.com/Excel/Pivots/pivottables.htm
http://www.contextures.com/xlPivot02.html

Regards,
Ryan---

--
RyGuy


"Steve" wrote:

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.

adding the qty's of products from several worksheets.
 

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---

--
RyGuy


"Steve" wrote:

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.

"ryguy7272" wrote:

A Pivot Table should do that for you:
http://peltiertech.com/Excel/Pivots/pivottables.htm
http://www.contextures.com/xlPivot02.html

Regards,
Ryan---

--
RyGuy


"Steve" wrote:

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.