Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set up database that updates automatically Qty's entered | Excel Worksheet Functions | |||
Adding the sales values of products | Excel Discussion (Misc queries) | |||
adding worksheets | Excel Discussion (Misc queries) | |||
Adding Products | Excel Worksheet Functions | |||
adding worksheets together | Excel Discussion (Misc queries) |