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'
<tbody>
</tbody>
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>