VBA find header and clear contents

[Legacy 287389]

Hi good people!,

Please assist me with this:

Sheet1 = Database
Sheet2 =View

Sheet "Database" has the following:

A1 = "01-01-2019"
A2 = "Handle"
B2 = "Win"
C2 = "Games"
D2 = "Theo Hold"

Then E1 = "02-01-2019"
E2 = "Handle"
F2 = "Win"
G2 = "Games"
H2 = "Theo Hold"

and so the pattern goes.

The columns with headers "Handle", "Win", "Games" and "Theo Hold", contain data underneath them going down to row 512. I am looking for a code please that will, once the button is clicked, give a msgbox prompting the date from where I want to clear data, then allow me to input for example "05-04-2019", after which the code will find the date in the Database sheet, find the cell in row 3 below this date, select from this cell down to row 512 and also select all cells going to the right, then clear all that content. The button will be on the View sheet.

I hope I have explained my need properly. please help me with this?..all help will be greatly appreciated!..Thank you kindly..

 

[RoryA]

As I said, we don't delete accounts. If you don't want to use the forum any more for whatever reason, just stop using it. If you really want I can deactivate your account too.

 

[Legacy 287389]

please deactivate...thank you..