Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi there,
i have 3 work sheets with these data fields: RO, ROC, CO RO is customers order where the new orders for the model will be placed. the data field is "model","po number", "ord qty", "del date" ROC is when customer request to make changes to the RO they already made the data field is "model","po number", "change qty", "change date" CO is issued when the customer finally confirms their order the data field is "model","po number", "del qty", "del date" As you all may seen, the model name and po number must matched up in these 3 fields. I want to use pivot table function to make a table that sort according to model name, po number and shows the RO qty, del date, then shows ROC qty and dat, and the CO qty and date. but for the pivot table to work, i have to join the info's of the RO, ROC, CO work sheet together according to the model name and po number. Although using vlookup function to match and then copy the qty and date info is relatively straight forward, IS THERE ANYWAY I CAN create multiple pivot table field lists (eg. RO, ROC, CO field list) and throw the info into a single pivot table, so that Excel will automatically group according to model name and po number for me? i hope i post my question clear and understandable. really appreciate the feedback from you all. thank you all very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
Pivot Table groups & cumulative totals | Excel Discussion (Misc queries) | |||
Pivot Table Groups | Excel Worksheet Functions | |||
Pivot Table Date Groups | Excel Discussion (Misc queries) | |||
pivot table and groups | Excel Worksheet Functions |