Good Morning and thanks in advance for your help!

I have created a workbook that autofilters a list of unique details and creates an individual worksheet within the excel workbook for each value, what I can't for the life of me work out is how to delete worksheets that have been created if the value no longer appears within the same list.

E.G.

Column A contains

Dog
Cat
Horse

This creates three sheets Dog, Cat, Horse

I complete all the work on the 'Dog' sheet and remove this from column A, how can I then run a further macro to realise that the worksheet 'Dog' no longer appears in the list and deletes the sheet for me?

I am driving myself crazy with this at the moment.

Please help

Regards

Rick