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 |
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 |
All times are GMT +1. The time now is 05:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com