Export chunk of data to another sheet based on condition

[obsoletepower]

Hello,

I have an excel spreadsheet which is a master list of the applications we use here at work and i would like to export data from the master to different tabs based on various conditions. This should update automatically when a change is made on the master list ie. if an application has its status changed. I have thought about using VLOOKUP and using a bunch of IF statements except 1. they don't update when something changes like if an application is added, it will have to manually be added to each tab and 2. it has to be done cell by cell.

Basically what I need is a way for excel to look at the master list and export the corresponding rows to the other sheets based on each sheet's condition.

Can anybody help me achieve this please? It will be greatly appreciated.

 

[Smitty]

Welcome to the Board!

You could probably use a Change event that's triggered by a status change. The same could go for new data, provided the status field was filled in last, otherwise you risk not copying all of the data for that record.

Do these records need to be cut or copied?

How do you tell Excel what the destination sheet for each record is?

Can you post a shot of your sheet? See the link beneath my sig for how.

 

[obsoletepower]

Welcome to the Board!

You could probably use a Change event that's triggered by a status change. The same could go for new data, provided the status field was filled in last, otherwise you risk not copying all of the data for that record.

Do these records need to be cut or copied?

How do you tell Excel what the destination sheet for each record is?

Can you post a shot of your sheet? See the link beneath my sig for how.

I actually figured this out using pivot tables. Thank you for the speedy reply!!