Kevin wants to clear out data for yesterdayâs shift worksheet any time someone opens the Workbook. Using the formula from Episode #1452, plus four tiny macros added he has added, Bill shows us the solution today in Episode #1453. "Learn Excel 2010".