Home |
Search |
Today's Posts |
#1
|
|||
|
|||
making one material list from mulitple vendor material lists
I have a work book with several vendor material list. I would like to add
another sheet that consolidates the different sheets. Example: Each Vendor material worksheet has five columns. Column A quantity you want, B model number, C description, D List price, and E is total Price (Column A times Column D). After choosing the quantity of the differnet items on the differnt sheets, I would like to combine all of the differnt rows on one Combined Vendor material work sheet that contains all five columns. I hope my question is as clear as mud. Thanks |
#2
|
|||
|
|||
Hi,
Assuming your sheets are well structured i.e. the rows and columns are aligned across all the sheets, you can use the Consolidate function from the Data menu Regards, Ashish Mathur "In the beginning" wrote: I have a work book with several vendor material list. I would like to add another sheet that consolidates the different sheets. Example: Each Vendor material worksheet has five columns. Column A quantity you want, B model number, C description, D List price, and E is total Price (Column A times Column D). After choosing the quantity of the differnet items on the differnt sheets, I would like to combine all of the differnt rows on one Combined Vendor material work sheet that contains all five columns. I hope my question is as clear as mud. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Data Lists | Excel Worksheet Functions | |||
making a non-validation list | Excel Worksheet Functions | |||
Lists: Clicking on one item in one list and getting certain info i | Excel Worksheet Functions |