if condition is met then copy the row data into a worksheet for multiple sheets/conditions

[Alberino]

Hi,

whats the easiest way to get the data (which is pulled in from 2 other workbooks) into regional tabs ?

SO from the table below if the region column = 'Auckland' then move the entire row to the Auckland tab and so forth for all the other regional tabs.
once the data is in the regions i need to be able to filter and sort it without to much hassle of it constantly changing the layout as it updates the data from 'ALL.DATA'

GT Job Code	SIZE.1	TYPE	REGO	CUSTOMER CODE	NAME	STREET	CITY.1	REGION.1	Rep
FT10	1900	Trailer Tank	Q458F	100968	Vanner Logging Ltd		Taupo	Bay of Plenty	TP
FT1000	10000	Double Skin 10000		7871	Drill Force	9 Rawson Way	Takanini	Auckland	BT
FT1001	3000	Double Skin 4800		102932	The Urban Quarry Ltd	8 Alfred Street	Onehunga	Auckland	BT
FT1002	4600	Container Tank		5267	PEACOCKE LOGGING LTD		Kaingaroa	Taranaki/ wanganui	TP
FT1003	4800	Bulka 4800		7611	Manga Jivan	312 Union Rd	Pukekohe	Auckland	BT
FT1004	4800	Bulka 4800		100677	McCann Bulk Ltd		NormanbyTaranaki	Taranaki/ wanganui	TP
FT1005	4500	Bulka 4800		100694	Grass Growers		Hamilton	Waikato	TG
FT1006	10000	Bulka 10000		100707	Contract resources		NormanbyTaranaki	Taranaki/ wanganui	TP
FT1007	2000	Double Skin 2000		101150	Premier Pavers Ltd		Tauranga	Bay of Plenty	EF

<tbody>
</tbody>

 

[stroffso]

Can you not just make seperate tabs with pivot tables off the all data tab and then filter on the region with a slicer? Then just refresh pivots on all data update?

 

[Alberino]

I was wanting more of a VBA option