Once again,

too hard for me but I tried a lot


My issue :

I have a commun ID column (i.e column D) on both sheets (i.e sheet1, sheet2) with different data on each rows

for each row x on sheet 2 I'd like to test if : it finds the common ID on sheet 2 + sheet1.range(E:X) is empty

then select range(E:X) from sheet 2

paste it in sheet1.Cells(D).offset or Sheet1.range(E:X)


Important note : I have several ID with different data per sheets and I need to copy each ID from sheet2 to each ID in sheet1. it means when vba is searching for an ID in sheet 2, it shouldn't stop to the first value and to pick up the one without data in the E:X range as it where they are paste.

Do you see what I mean ?

On difficulty I encountered is to "call" the row where vba finds the ID in sheet1


written lke this it doesn't sound really difficult to do but I got confused.

This is one of the code I tried, but either it fails or it gives an error. Sorry I'm learning


thank you