View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Havenstar Havenstar is offline
external usenet poster
 
Posts: 17
Default Combine Multiple Worksheets

I am looking to combine data from two worksheets into one. The data is being
copied in from (2) different data sources so the column structure is not the
same, but the sheets have one common column that I would like to pull data
for. For example:

Sheet 1
A B
Part Number Description

Sheet 2
A B C
PO Number Part Number Price

Is it possible to to combine on one sheet if the Part Number is the same
pull in description, PO number and price?

Thanks in advance for any suggestions,
Havenstar