Soting Various Lists
I have to excel lists, one exported from a database, the other I created.
The first sheet is of Equipment Records with the following columns: Itemname(Column A), Itemdescription(Column B). The second sheet is a list of parts for the various equipment records: Partname(Column A), Partdescription(Column B), Itemname it belongs to(Column C). How do I make a sheet 3 that shows all Items from sheet 1 with any parts from sheet 2 that they might have sorted under them? Output Example: Item001 Chainsaw Part015 Bar Part023 Chain Item002 Pole Item003 Mower Part006 Blade Part007 Belt |
Soting Various Lists
Try using subtotals. Data-Subtotals.
"Blissfully Ignorant" wrote: I have to excel lists, one exported from a database, the other I created. The first sheet is of Equipment Records with the following columns: Itemname(Column A), Itemdescription(Column B). The second sheet is a list of parts for the various equipment records: Partname(Column A), Partdescription(Column B), Itemname it belongs to(Column C). How do I make a sheet 3 that shows all Items from sheet 1 with any parts from sheet 2 that they might have sorted under them? Output Example: Item001 Chainsaw Part015 Bar Part023 Chain Item002 Pole Item003 Mower Part006 Blade Part007 Belt |
All times are GMT +1. The time now is 07:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com