Ok I have looked over several consolidate data posts here but yet to find any that will help solve my consolidate/combine dilemma.
SETUP
-I have 2 worksheets (Sheet1 & Sheet2) in the same workbook.
-Both have the same Column Headers (Columns A through to V).
-Sheet1 has about 6K rows of data & Sheet2 has about 4500 rows of data
-Many rows in Sheet1 already exist in Sheet2, but Sheet2 has new data (rows) missing in Sheet1
DILEMMA
Now I would Like to consolidate the data from both Sheet1 and Sheet2 but I would like a macro to do 3 things:
1) Check to See if there is matching record/row in Sheet 2 based on the data in COLUMNS G,H & I. If an exact match exists then then keep the record in Sheet1 but fill in the missing data from any of the other columns that may exist in Sheet2.
e.g if Row 3 in Sheet1 is blank in column A but has the value "Active" in Sheet2, copy the value from Sheet2 into the corresponding column in Sheet1. (Columns in both sheets are identical)
2) If a record only exists in Sheet2, copy into consolidated data output
3) All unique records in both Sheet1 and Sheet2 should be in final output
I hope this makes sense and can further clarify as needed. Thanks so much in advance for your help!
SETUP
-I have 2 worksheets (Sheet1 & Sheet2) in the same workbook.
-Both have the same Column Headers (Columns A through to V).
-Sheet1 has about 6K rows of data & Sheet2 has about 4500 rows of data
-Many rows in Sheet1 already exist in Sheet2, but Sheet2 has new data (rows) missing in Sheet1
DILEMMA
Now I would Like to consolidate the data from both Sheet1 and Sheet2 but I would like a macro to do 3 things:
1) Check to See if there is matching record/row in Sheet 2 based on the data in COLUMNS G,H & I. If an exact match exists then then keep the record in Sheet1 but fill in the missing data from any of the other columns that may exist in Sheet2.
e.g if Row 3 in Sheet1 is blank in column A but has the value "Active" in Sheet2, copy the value from Sheet2 into the corresponding column in Sheet1. (Columns in both sheets are identical)
2) If a record only exists in Sheet2, copy into consolidated data output
3) All unique records in both Sheet1 and Sheet2 should be in final output
I hope this makes sense and can further clarify as needed. Thanks so much in advance for your help!
