Juriemagic
New Member
Hi good people!,
first things first:...I have posted this question on mr excel, got no response in almost a week, then posted on excelhelp, only to be told it's a duplicate. i have asked the moderators on both sites to please remove my account. I am posting here in the hopes that I am not trespassing and with the hope to receive help. the link to mrexcel is this: www.mrexcel.com/forum/excel-questions/1091700-vba-find-header-clear-contents.html, if it still works.
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..
first things first:...I have posted this question on mr excel, got no response in almost a week, then posted on excelhelp, only to be told it's a duplicate. i have asked the moderators on both sites to please remove my account. I am posting here in the hopes that I am not trespassing and with the hope to receive help. the link to mrexcel is this: www.mrexcel.com/forum/excel-questions/1091700-vba-find-header-clear-contents.html, if it still works.
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..
