Find 'x' word in data set > clear contents from row containing 'x' & all below

[KevyWevz]

Hello Excel and VB gurus,

I would like to request your help with and Excel macro I am attempting to create to save me some time/remove human error.

I regularly extract a large data set, usually between 50,000 to 200,000 rows of data across 11 columns (A:K). The problem is, the data usually comes with a 'summary' section also that I would like to delete entirely as it is simply a shorter duplication of what I have already pulled.

So in column A, the word Summary will mark the beginning of this summary and my goal is to have a macro prepped that locates the word Summary and then clears the contents of the row the word exists in and all rows below that - thus enabling me to simply click anywhere in the sheet and CTRL+A & CTRL+C to copy the remaining data without worry of unwanted data that will mess up the calculations the data will be used in.

May I request help in how to build such a piece of code?

Any help at all would be very much appreciated.

Kindest regards,
KW

[Fluff13]

How about

Please Login or Register  to view this content.

[KevyWevz]

How about

Please Login or Register  to view this content.

Boom, that does it!

Many thanks, Fluff! Much gratitude

[Fluff13]

You're welcome & thanks for the feedback