Delete Table Rows Based on Specific Text

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!

This isn't very elegant, but it sounds as if something like this is all you need:

Please Login or Register  to view this content.

Ah.

The whole row can't be deleted then, obviously. But you can delete just the data (the total figures) in the table, I think. How many columns is your GroupAuxDaily table? If it's located in columns A through G, for example, then something like this should work:

Please Login or Register  to view this content.

You can also put that in a loop, of course:

Please Login or Register  to view this content.