Macro to delete rows based on criteria, for all sheets in book

Good morning all!


I have about 60 sheets in one book, all with very different names. Each sheet has the same exact list of data.

I need a macro that will go through each sheet and delete all rows, except for the header, in which the data in column D does not match the sheet name. If possible, can it also delete the row formatting as well so I dont have to go back and do this manually?

I appreciate any help that can be provided!

Hi,

See if this helps. Try it in a copy of your workbook since changes cannot be undone.

Thanks

Please Login or Register  to view this content.