Macro to sort and Insert

[Pauljj]

I need a macro, that will copy the date below from Sheet 3 to Sheet 2, then sort by column Y first, then column V. This I think is probably easy enough, what I need to do as well as whenever there is a change in the Y column, after sorting I need a row Inserted. For example after sorting. In the Y column there might be all CAN codes, it then changes to JAP codes, if this happens a row needs to be inserted with JAP in the P column...hope that makes sense !!

Cheers

Paul

TEST.xls
	P	Q	R	S	T	U	V	W	X	Y
2011	PANGKORLAUTESTATES	PKG	0	n/a	0	n/a	0	n/a		MAL
2012	CHIVA-SOM	HHQ	5668	n/a	28	n/a	157	n/a		THA
2013	THEFAIRMONTORCHID	KOA	1024	n/a	6	n/a	32	n/a		HAW
2014	FAIRMONTSANFRANCISCO	SFO	5272	n/a	40	n/a	139	n/a		USA
2015	BUFFALOMOUNTAINLODGE	YBA	264	n/a	2	n/a	13	n/a		CAN
2016	CROWNEPLAZALACONCHA	EYW	275	n/a	5	n/a	14	n/a		USA
2017	MARATABASAFARICOMPANY	MK1	174	n/a	8	n/a	0	n/a		SOA
2018	SHINAGAWAPRINCEHOTEL	TYO	5940	n/a	138	n/a	358	n/a		JAP
2019	LAPLAYABEACH&GOLFRESORT	APF	376	n/a	1	n/a	9	n/a		USA
2020	BAYOFISLANDSLODGE	OP1	0	n/a	0	n/a	0	n/a		NZL
2021	RAWHITIBOUTIQUEB&B	WLG	62	n/a	2	n/a	3	n/a		NZL
Sheet2

 

[Pauljj]

Deos anyone have any ideas ??