Hello,
I know I've seen similar posts on here for a problem like mine, but I've been unable to figure out a solution from previous commentary. I want to create a simple macro to locate a specific row, delete that row, and then delete all rows below it.
For example, in the attached file row 30 contains headers for deactivated accounts. The information for these accounts is directly below. Rows 1 through 29 contain information for active accounts. However, the number of active accounts could change daily - meaning I can't just delete downwards from row 30 each day. The deactivated accounts contain a column heading (column B) which reads "GSP Acct No". If a macro could find which cell that "GSP Acct No" is in, delete that row and all rows below, then I would be left with only relevant information on my worksheet.
Again, I apologize for the simplicity of my request. I am a beginner and looking to learn more, so I appreciate any insight that anyone can share.
Thank you.
DeleteRowsExample_MACRO.xlsx
Bookmarks