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.
|