Remove Entire Row, when a query updates (not only the its interval)

[TEIXEIRE]

I have a query on Excel which is connected to a Sharepoint List, and the collunms goes from A to O (for example), and I added more colluns and create a macro to send emails for each correspondent value, it works well, BUT, sometimes one line could be deleted from the Sharepoint list, and when the query is updated, this line is erased from A to O, but the dates of e-mail sending are in the following collunms, and I need when the query updates, eliminate not only the query's interval, but also the correspondent colluns created to track the dates of the sendings.

Thanks in advance!