Hey everyone,
So I'm trying to format a large series of data involving names and addresses. Some of the rows however consist of names and no addresses while most of it consists of names with addresses.
What I want to do is design a macro to delete all rows that include names and no addresses.
The way its formatted is column A and B consist of first and last name while column c consists of the address so a macro would have to essentially scan column c for all cells with no data and then delete the corresponding row associated with that cell.
I've just been stumped on exactly how I would go about doing that.
Bookmarks