Delete Rows Until "Total" Found in Column A

[Buddy7]

Is there a macro that will begin in cell A2 and delete rows until the contents “Total” is found in a random row in Column A?

[shg]

Try this:

Please Login or Register  to view this content.

[Buddy7]

Thank you friend. This is going to be very helpful to me.

[shg]

You're welcome. Would you please mark the thread as Solved?

[Buddy7]

Sure thing partner!