<TABLE width="100%"><TBODY><TR><TD>
I have one worksheet which contains all my data on a continous basis i.e. a main database, with the different types of sectors i.e. finance, health and whether they are active or not.
I would like the details to be copied to another sheet dependant on the sector i.e. all health to health tab and all finance to finance tab regardless of whether they are active or not and then for all active to go the active tab and all non active to go to non active tab, regardless of sector.
All relevant sheets exists i.e. Main Database (source), Active, Non Active, Finance, Health.
The database is set as follows:
Status Sector
1 Active Public
2 Active Other
3 Active Other
4 Active Service
5 Active Service
6 Active IT
So anything which is active, regardless of sector goes to the Active sheet in the next available row.
Anything which is in the relevant sector goes to the sector sheet in the next available row, regardless of status.
The Status and Sector columns have drop down menus with preset details, so other details cannot be typed in. I would want this to happen each time a drop down is changed should it be a change in either sector or status as if the status changes then it goes into the relevant status sheet and should for some reason one had the company under the wrong sector, once changed the details will show up in the correct sector sheet.
Can anyone help?
</TD></TR></TBODY></TABLE>
I have one worksheet which contains all my data on a continous basis i.e. a main database, with the different types of sectors i.e. finance, health and whether they are active or not.
I would like the details to be copied to another sheet dependant on the sector i.e. all health to health tab and all finance to finance tab regardless of whether they are active or not and then for all active to go the active tab and all non active to go to non active tab, regardless of sector.
All relevant sheets exists i.e. Main Database (source), Active, Non Active, Finance, Health.
The database is set as follows:
Status Sector
1 Active Public
2 Active Other
3 Active Other
4 Active Service
5 Active Service
6 Active IT
So anything which is active, regardless of sector goes to the Active sheet in the next available row.
Anything which is in the relevant sector goes to the sector sheet in the next available row, regardless of status.
The Status and Sector columns have drop down menus with preset details, so other details cannot be typed in. I would want this to happen each time a drop down is changed should it be a change in either sector or status as if the status changes then it goes into the relevant status sheet and should for some reason one had the company under the wrong sector, once changed the details will show up in the correct sector sheet.
Can anyone help?
</TD></TR></TBODY></TABLE>
