ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do i compare values from two sheet and copy & paste if values match? (https://www.excelbanter.com/excel-programming/293507-how-do-i-compare-values-two-sheet-copy-paste-if-values-match.html)

rozb

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


All times are GMT +1. The time now is 11:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com