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:

For Row = 1 To 100    '<-----  change the 100 as needed
  If Cells(Row, "G") = "Totals" Then
      Rows(Row & ":" & Row).Select
      Selection.Delete Shift:=xlUp
  End If
Next

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:

For Row = 1 To 100    '<-----  change the 100 as needed
  If Cells(Row, "G") = "Totals" Then
      Cells(row, "A") = ""
      Cells(row, "B") = ""
      Cells(row, "C") = ""
      Cells(row, "D") = ""
      Cells(row, "E") = ""
      Cells(row, "F") = ""
      Cells(row, "G") = ""
  End If
Next

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

For row = 1 To 100       '<-----  change the 100 as needed
  If Cells(row, "G") = "Totals" Then
      for column = 1 to 7
         Cells(row, column) = ""
      next column  
  End If
Next row