Hi

I have a table of jobs my organisation does for our customers.

I currently run an advanced filter to display the jobs which have not been invoiced on a seperate sheet - displays all jobs which are marked as 'No' in the invoiced column. (to make it easier to search)

I would like to know if it is possible to set up excel so if I change the jobs in the filtered table from 'No" to 'invoiced' the corresponding record in table with all the jobs is automatically updated, and the job just marked as invoiced dissapears from the filtered table.

Also is it possible to have this table auto updating, or set up a button i can click on to update the tables.

Any help is much appreciated