Hello Everyone,

I want to create a macro that will find a text string called "Season Average" in the entire workbook and delete a range of cells above it 4 cells longs starting right above the text and then going left.

Example is if "Season Average" is in cell D11, than I want the cells D10, C10, B10 & A10 Deleted and the cells to shift up

This happens throughout the entire workbook and multiple times on each work sheet in different spots not consistently same cells

Thanks for you help!