Copy if match - offset

[emukiss10]

Hello!

VBA needed.

In sheets(5) column "A" every 3rd row (A3, A6, A9 and so on) I have some numbers.
I'd like to search for those numbers in column "F" of sheets(3). (F2:F)
If match I would like to copy contains of cells from column "DG" and "DI" sheets(3) to columns "M" and "N" sheets(5) to the rows that was matched.

Best Regards
W.

 

[emukiss10]

Bump

 

[emukiss10]

Bump

 

[Youngdand]

Bump

Question

Will the sheet you want to lookup data in have duplicates of what you are searching for?

Do you want a VBA solution or a formula?

Regards,

Dan.

 

[emukiss10]

I would like VBA script to add to my macro

no duplicates.

 

[emukiss10]

Bump

 

[emukiss10]

Bump

 

[emukiss10]

Bump

 

[emukiss10]

Bump (going for a record :/)

 

[emukiss10]

Bump (Day 15 b-1)

 

[emukiss10]

Bump (Day 16 b-1)