Create a Table from data held in an existing table conditionally

[Closed]
Report
-
Hello,

We have a job monitoring excel we have been using where we have an existing table that holds the status of all possible jobs we are investigating.

We would like to be able to produce a sheet & table that will auto-populate with jobs we have allocated as becoming "Active". That way we can start to allocate resources to any project without worrying one is overlooked.

we can produce a sheet that produces blank lines for projects that don't meet the requirements however we would prefer to have all the data concise.

Thanks in advance!