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'


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

 

[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