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? 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?
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 HIS www.nickhodge.co.uk "Peanut" wrote in message ... 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?
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. "Nick Hodge" wrote: 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 HIS www.nickhodge.co.uk "Peanut" wrote in message ... 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... |
All times are GMT +1. The time now is 02:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com