Find Cell Delete All Rows Below

[Tyler_Durden]

Hi,

I would like to be able to find the cell in column A with the name of "Grand", and take that row and all the rows below that and delete the contents... Since everday though the number of rows will be different I can't just record this... here is an example spreadsheet...