View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rozb rozb is offline
external usenet poster
 
Posts: 10
Default How do i compare values from two sheet and copy & paste if values match?

1. A value on sheet 1 in Row "A" (Row A2:A156) needs to be matched to a "=" value on sheet 2 in Row "A" (Row A2:A6), and then Cells (J & x : AH & x) need to be copied from sheet 2 and pasted in sheet 1 row of the value matched Cells (J & x : AH & x)

Question

How do i compare values from two sheet and copy and paste if values match

Thanks
Rozb