How do I enter a formula that will delete a line when a cell = 0?
I need to create a formula that will delete a line in one worksheet when a
cell in another worksheet equals zero. |
How do I enter a formula that will delete a line when a cell = 0?
Not possible, formulas can never delete anything, you could sort of hide it
using white fonts and conditional formatting but to delete you would need an event macro -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Jen" wrote in message ... I need to create a formula that will delete a line in one worksheet when a cell in another worksheet equals zero. |
All times are GMT +1. The time now is 08:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com