| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I consolidate data from several spreadsheets into one.
I have several spreadsheets containing data that I would like to consolidate
into one spreadsheet. Each of the spreadsheets have a common Product Code field column but all the other field columns are different. Obviously I can cut and paste the data into one spreadsheet but that will leave me with several rows of data for the same Product Code. Note also that not all the Product Codes are listed on all the spreadsheets, I do however have one master spreadsheet with all these Product Codes. This is what I want to see and for example. eg Product Code Description 1 Description 2 Cost Trade Price Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i consolidate 13 spreadsheets onto one | Excel Worksheet Functions | |||
| consolidate data | Excel Discussion (Misc queries) | |||
| help to consolidate data | Excel Worksheet Functions | |||
| Consolidate Spreadsheets | Excel Discussion (Misc queries) | |||
| Consolidate multiple spreadsheets into a single workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
