morsoe
10-06-2010, 02:16 PM
I have two worksheets. The first one is named "updates" and the second one is named "catalogue".
Column A in "updates" is named <product_key>. I want to match the <product_key> with column A in the worksheet "catalogue" which is also named <product_key>.
If there is a MATCH on the <product_key> the row in the worksheet "catalogue" should be updated with the entire row from the worksheet "updates".
If the is NO MATCH one the <product_key> the row from the worksheet "updates" should be copied and pasted to the first empty row in the worksheet "catalogue".
How can I do that?
Column A in "updates" is named <product_key>. I want to match the <product_key> with column A in the worksheet "catalogue" which is also named <product_key>.
If there is a MATCH on the <product_key> the row in the worksheet "catalogue" should be updated with the entire row from the worksheet "updates".
If the is NO MATCH one the <product_key> the row from the worksheet "updates" should be copied and pasted to the first empty row in the worksheet "catalogue".
How can I do that?