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? :help

Thanks so much

Andrew