Is there a way to have a formula stop calculating/running once another cell is filled out with data? So for example, A2 would contain a date, B2 would be the difference between today's date and the date in A2, which would update anytime the spreadsheet is opened. C2 would then contain a final date, when C2 is populated I would like the formula in B2 to stop running. I apologize if my wording is a bit confusing but any help with this is appreciated. Thanks
You could post a workbook and show an example.
Entia non sunt multiplicanda sine necessitate
Right Click on your Sheet name at the bottom of excel and select view code
Paste this code in the window that opens and close it. The macro will run each time you make a change on the sheet.
Please Login or Register to view this content.
Last edited by mehmetcik; 12-27-2016 at 07:39 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thanks a lot for the help! Out of curiosity is there a way to do this without using VBA?
Basically No.
You could do it by using a circular reference.Originally Posted by PopeJP2
First, you have to change a setting...
In Excel 2010, goto File>Options>Formulas
Check: Enable iterative calculation
OK out
Then, enter this formula in B2:
=IF(C2<>"",B2,TODAY()-A2)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks for the help guys. I really appreciate it.
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks