Hello,

I have info in columns A to AC in worksheet 1 and 2. I need to merge
them as follows:
If item number (Column A) exists in sheet 1 and 2, bring the full row
across from WS2 and replace the entry in WS 1 except column C which
must remain the original value as in WS1


Thanks




On Jan 29, 1:05 pm, "splat" wrote:
Sorry, ammended:



I have info in columns A to AC in worksheet 1 and 2. I need to merge
them as follows:
If item number (Column A) exists in sheet 1 and 2, bring the full row
across from WS2 and replace the entry in WS 1 except column C which must remain the original value as in WS1

Thanks- Hide quoted text -- Show quoted text -