Hello,
How can I match and combine records across two excel sheets. I have two excel sheets containing record information, about 6 columns for each record. I would like to be able to match records by part # and combine the columns for each record from each sheet. So each new record will include all available columns from both sheets for each specific record (each record is a row). Part # in both sheets is column A, while the rest of the columns have different information. The formula needs to check for each part# in column A sheet 1 and find the same part # in column A in sheet 2 and then combine the information. There are 500 records so it will need to be able to do this automatically for all records.
The combined records could be displayed in a new sheet # 3 of combined within sheet 1 or 2.
If possible please also explain how to implement the formula since I am not excel savvy.
Configuration: Windows Vista Internet Explorer 7.0
Copy rows from one excel sheet to another Excel automatic create new sheet Excel chart copy chart to another sheet Excel combine multiple fields in one cell Excel copy & paste between sheets Excel help infor in sheet Excel vba .select multiple sheets Excel vba run macro on activate sheets How to find specific cells in excel sheet How to insert row with formulas in 2 sheet with macro excel How to make sheet in excel which has 30 sheets and data transfer automatically How to save form data into excel sheet I want to lookup two values for same record in excel in another sheet Insert animated gif into excel 2007 sheet? Percentage by excel sheet Vb6 excel delete extra rows sheet2 Vba excel create a copy of excel sheet new file Visual basic - how to paste data from excel sheet to another excel sheet