Hi guys,
I am working with a rota and there is a grid with all the data with names across Row 6 and the dates of the year down Column A. In the grid are all sorts of entries, with "Off", "Holiday" etc but all shifts are written in the form "7am-6pm". I am looking to clear all the cells of...