Copy and Paste
 

How do you

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)

Copy and Paste
 

Look at the vlookup worksheet function

--
Regards,
Tom Ogilvy

"Rozb" wrote in message
...
How do you:

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) .

Copy and Paste
 

Thanks Tom

----- Tom Ogilvy wrote: ----

Look at the vlookup worksheet functio

--
Regards
Tom Ogilv

"Rozb" wrote in messag
..
How do you
1. A value on sheet 1 in Row "A" (Row A2:A156) needs to be matched to
"=" 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 valu
matched Cells (J & x : AH & x)