Lookup a value on a table, if does not exist then delete a large range of data

[leocleverdon]

Hi

I hope someone can help. I have a a table that has energy solutions, with a corresponding page further down the document on the same sheet. What I need is a piece of code that firstly sorts the data in the table, deletes and rows the n/a line in payback coloumn, as these solutions are not viable, then looks for the page that has the solution description and detail and deletes it, because it is not in the table. I have tried different ways, I can get it to delete the N/A but cant find any code that deletes the releveant pages.

Each page lower down in the document has the above headings.


I do hope someone can help!

Thanks

 

[portews]

Are these table objects, or just ranges of the worksheet? If they are tables, what are the table names? What are the starting rows and columns of this information and the "pages" further down?