Thread: Consolidate data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
splat splat is offline
external usenet poster
  
Posts: 22
Default Consolidate data


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

Reply With QuoteReply With Quote