-
Solved: VBA to delete a row in another worksheet
Hello,
I am looking for help creating a Macro that will delete an entire row in another worksheet.
A B C D
1 A ? Macro button
2 B ) Macro Button
My workbook contains two worksheets. The worksheets are called "Active Residents" and "PY Query" respectively. In the Active Residents worksheet, I want to have an "Override" button inserted. What I mean is on the made up excel template just above here, if I want to override the first row above, I would select the Macro Button. The macro button would match the Column A Criteria in worksheet "Active Residents" to Column V Criteria in the worksheet "PY Query". Once the criteria is matched, I want the macro to delete the entire row in the "PY Query" where the match is made. Could someone help me and create VBA for this?
Thanks so much
Andrew
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules