Paste Cell on a certain column and variable row

[MariPip]

Is there any way for me to do the following thing:
Have a macro search for the row in sheet2 (column C) with the same value as Cell B4 in sheet1, lets call it row x, and paste the value from sheet1 Cell H21 onto The cell (x, L) (row x and column L).

Thank you !

[Trebor76]

Hi MariPip,

Try this:

Please Login or Register  to view this content.

HTH

Robert

[MariPip]

Works perfectly thank you so much

[Trebor76]

You're welcome and thanks for marking the thread as solved