dont know if this is even possible but i would like to use a formula within a macro and have it run every time the workbook is opened. the formula would do the following
if(e21+56>=an21)then delete contents of cell f21
at the moment i have to check through and delete these manually for 700 rows every week, quite time consuming as you can imagine so if i could automate it, it would save me a lot of hassle
any ideas greatly appreciated
thanks
Bookmarks