Hey guys,

I'm new on this forum. I am urgently seeking help for the problem mentioned below:

I want to copy data from "sheet 4" (D8:D1000)&(E8:E1000)&(k8:k1000)

and paste to "sheet 2" (B6) onwards.

Criteria:-

Criterion (1)
Criterion range "sheet 4" (C8:C1000), criterion: should match with the value entered in "sheet 2" (B3)

Criterion (2)
Criterion range "sheet 4" (G8:G1000), criterion: Should be bigger than or equal to the date (mm/dd/yyyy) entered in ''sheet 2'' (M3)

Criterion (3)
Criterion range "sheet 4" (G8:G1000), criterion: Should be smaller than or equal to the date (mm/dd/yyyy) entered in ''sheet 2'' (N3)

I have tried everything but no success. Formula or macro, any help would be really appreciated. Need help urgently.

Look forward to the helping hands of this famous forum.

Cheers!!!!