I have a spreadsheet of all my current projects which have the following columns - job no, job name, fee, start date, status
On a separate sheet (in a separate workbook) I want a dynamic list of jobs which are "live" - which is based on status column.
I have several statuses for jobs and want a list to be dynamic when the statuses are either "LIVE", "PROGRAMMED" or "DELIVERED" The list will also drag through each of the other column values for each job.
I could do this with filters but I need it in a spearate spreadsheet altogether and just want to simply show the list dynamically without any user input. The list needs to work in realtime so that when something changes in the main spreadsheet (in any of the columns) then the list reflects this straight away - e.g. the fee is changed. Also when the status changes either to / from one of the statuses above the row appears / disappears from the list.
I've also thought of a pivot table but would rather it didn't go down this route as I weant no user input at all and to auto update.
Is this possible?
On a separate sheet (in a separate workbook) I want a dynamic list of jobs which are "live" - which is based on status column.
I have several statuses for jobs and want a list to be dynamic when the statuses are either "LIVE", "PROGRAMMED" or "DELIVERED" The list will also drag through each of the other column values for each job.
I could do this with filters but I need it in a spearate spreadsheet altogether and just want to simply show the list dynamically without any user input. The list needs to work in realtime so that when something changes in the main spreadsheet (in any of the columns) then the list reflects this straight away - e.g. the fee is changed. Also when the status changes either to / from one of the statuses above the row appears / disappears from the list.
I've also thought of a pivot table but would rather it didn't go down this route as I weant no user input at all and to auto update.
Is this possible?