|
|
#1
09-11-2013, 07:29 AM
|
|||
|
|||
Combine Data From 2 Sheets into a new sheet
I have a work book that contains 2 sheets of data. It contains pricing information for new and used parts. In these sheets the same number for the part might be on both sheets but there are two different prices. I am looking for a way to combine these sheets to contain only unique part numbers, but contain all of the prices.
I have created a sample work book to illustrate what I am trying to accomplish. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Formulas in many Sheets referring to corresponding column in one sheet | ue418 | Excel | 0 | 07-11-2012 02:04 AM |
| sheet 2 data highlight in sheet 1 | gsrikanth | Excel | 1 | 04-21-2012 06:25 PM |
| If two geographical data match in two sheets, copy unique id/code found in one sheet | alliage | Excel | 1 | 09-01-2011 05:23 AM |
 How to combine different cells data in one cell?
|
Learner7 | Excel | 1 | 07-28-2010 12:07 PM |
|
How do I merge data from one sheet in a workbook out into multiple sheets
|
nolesca | Excel | 4 | 06-07-2010 08:13 AM |
Windows 7 64bit 
Office 2007
Threaded Mode