This is a spreadsheet that is manipulated daily. There is a cell that is
integral to a data validation that needs to be checked off as a daily
routine. If the "check mark" is unintentionally carried over from a previous
day, there could be issues with audit reviews. I simply want to see if there
is a way to prevent this from happening. I am wanting specific cells to be
cleared out at the start of a new day (without creating a new spreadsheet) -
so I can know without a doubt that this item is being completed daily.
As far as instructions, please be detailed, as I am still learning the
ins-and-outs of Excel. Thanks.