I have 10 excel workbooks each with numerous worksheets within each, labeled 'stock 1' to 'stock 45' for example. Now within each worksheet, i would like to delete the rows which contain specific dates around christmas (ie. 24/12/##, 25/12/##, and 26/12/##). The dates start in column A row 3.
Does anyone out there now now to do this quickly via a macro of some sort, as doing it manually would take about six months i reckon!
Thanks very much.