Hi There,
I have a list of data, each row has a status of new and old.
I need two new worksheets - one to display all rows with a status of new and the other with all rows with a status of old.
The master sheet will keep being added to and status' updated so I will need to formula to keep updating periodically.
Please see example spreadsheet attached - I have manually completed the 'All New' sheet, which I need to be auto.
Thanks in advance. Chloe.
Bookmarks