I have tried a few different scripts and just can't seem to get one to work correctly.

I am looking for a macro that will simply perform this action prior to me exporting this table to access.

I have a table on my sheet ExportSheet, called "GroupAuxDaily". The headers of the table start at G5 and can vary in length depending on the daily data entered.

When someone enters the data into this table, there is a pesky "Total" row that always export from the program. We paste multiple instances of this report one below another, so simply removing the first row doesn't work for the others.

Essentially what I need is a macro that will do the following:
In Table "GroupAuxDaily" remove any row where text "Totals" exists in the first column (G).

This will be placed before my export to Access code. thanks in advance!