Is there a way to delete a cell value based on a condition?

Is there a way to delete a cell value based on a condition?

Post by UGVhbnV » Wed, 04 Oct 2006 05:20:01


Is there a way to delete a cell value based on a condition? i.e. Each change
of day, the cell value in A2 will be deleted...
 
 
 

Is there a way to delete a cell value based on a condition?

Post by Nick Hodg » Wed, 04 Oct 2006 05:30:48

Peanut

You would have to use an event (say one of the change events) and then store
that in a range name or hidden sheet. You could then check this each time
the event fires and delete it if different and save the new one in it's
'store'

It will need code so give us more detail as to when this book is
used/updated etc.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

XXXX@XXXXX.COM
www.nickhodge.co.uk

 
 
 

Is there a way to delete a cell value based on a condition?

Post by UGVhbnV » Wed, 04 Oct 2006 05:55:01

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.