Find duplicates and copy offset to other sheet (Second Post)

[emukiss10]

Hello.

This is my second post about the same subject. Im sorry for double but it was not answered. Link to first post below.
https://www.mrexcel.com/forum/excel-questions/1045323-copy-if-match-offset-2.html

Ill try to explain it with an example this time.

What I need is:

1. "Check every 3rd cell from Sheets("fifth") column "A" against column "F" from Sheets("third")
(two sheets are being compared)
2. If value from "fifth" is found in "third" than copy cells DG and DI from "third" to N and M of Fifth

- Ofc the same row. If Sheets("fifth").Range("A30") is found in Sheets("third").Range("F822") than copy DG822 and DI822 from "third" to M30 and N30 of "fifth""


In this example

Sheets("FIFTH") A3 (654) was found in Sheets("THIRD") F5 and I need to copy from Sheets("THIRD") DG5 and DI5 to M3 and N3 Sheets("FIFTH")
the same with A6 (159) and so on till the last row.


SHEETS("THIRD")

	A	B	C	D	E	F	DG	DH	DI
1	data	data	data	data	data	123	WHITE	data	GREEN
2	data	data	data	data	data	456	CAR	data	PLANE
3	data	data	data	data	data	789	APPLE	data	BANANNA
4	data	data	data	data	data	987	CAT	data	MOUSE
5	data	data	data	data	data	654	FLY	data	DIG
6	data	data	data	data	data	321	HOLE	data	SPACE
7	data	data	data	data	data	159	TAR	data	DIRT
8	data	data	data	data	data	753	BLEACH	data	CLEAN
9	data	data	data	data	data	852	WALTZ	data	POLONEZ

<tbody>
</tbody>

SHEETS("FIFTH")

	A	B	C	M	N	O
1	1111	data	data	data	data	data
2	2222	data	data	data	data	data
3	654	data	data	.......	.......	data
4	3333	data	data	data	data	data
5	4444	data	data	data	data	data
6	159	data	data	.......	.......	data
7	5555	data	data	data	data	data
8	6666	data	data	data	data	data

<tbody>
</tbody>

I hope this will clear my goals.
Those sheets mayby big (50.000 +) so mayby dictionary or arrays would be better. (just thinking loudly)

Best Regards
W.

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).