I am looking to create a macro that helps format TableA by deleting unwanted rows. In TableA and TableB I have a list of titles in column "B". TableA has many more titles in column "B" and I would like to delete all rows that contain titles not found in TableB. I would also like to be able to set the search area for TableA as I plan to use this macro on varoius reports of different sizes.
Any help would be appreciated.
Any help would be appreciated.