autofill values for 1000 rows based on compare between two sheets

[MKLAQ]

Hi experts
I hope finding macro to achieve my requirements. I have sheet MONTHLY should match whole data with the sheet REPORT then should brings the values and fill in columns E,F for sheet REPORT also should be sorting as in sheet MONTHLY . I have about 1000 rows .

EX (1) (3).xlsm
	A	B	C	D	E	F
1	ITEM	GOODS	TYPE	MODEL	PU	SU
2	1	CR CCR-1	2010	BMW	380	12
3	2	CR CCR-1	2011	FV BMW	120	1203
4	3	TR CCB-3	TCR 1-TT	2009 MER	120	23
5	4	CCR-2	FI 2012	TIGUAN	120	45
6	5	CCB-2	2008	OPEL	100	11
7	6	TR CCB-3	TMIR 1-TT	2009 MER	101	44
8	7	CCB-1	CR/MN-1	2011 AUDI	80	12
MONTHLY

EX (1) (3).xlsm
	A	B	C	D	E	F
1	ITEM	GOODS	TYPE	MODEL	PU	SU
2	1	CCR-2	FI 2012	TIGUAN
3	2	TR CCB-3	TCR 1-TT	2009 MER
4	3	CR CCR-1	2011	FV BMW
5	4	TR CCB-3	TMIR 1-TT	2009 MER
6	5	CR CCR-1	2010	BMW
7	6	CCB-2	2008	OPEL
8	7	CCB-1	CR/MN-1	2011 AUDI
REPORT

result

EX (1) (3).xlsm
	A	B	C	D	E	F
1	ITEM	GOODS	TYPE	MODEL	PU	SU
2	1	CR CCR-1	2010	BMW	380	12
3	2	CR CCR-1	2011	FV BMW	120	1203
4	3	TR CCB-3	TCR 1-TT	2009 MER	120	23
5	4	CCR-2	FI 2012	TIGUAN	120	45
6	5	CCB-2	2008	OPEL	100	11
7	6	TR CCB-3	TMIR 1-TT	2009 MER	101	44
8	7	CCB-1	CR/MN-1	2011 AUDI	80	12
REPORT

 

[Alex Blakenburg]

I will leave it with you.
If you want to sort the REPORT based on columns B then C then D, use the last version I gave you or modify it if you want a variation of the that.
If you want it to be in the same order as Monthly and monthly does not use B C D then use the previous code.
Come back to us if you need further help on it.

 

[MKLAQ]

nobody see my thread and you gives me two choices . this more than what I deserve it
thank you very much for your help me .

 

[Alex Blakenburg]

You are very welcome. Glad I could help.