Hi Mehmetcik!
Yes your right! In my Excel formula it needs to determine the "terms" then calculate the amount then it will appear in column D. After calculation then the hiding & unhiding of rows with the value of zero in column D will take place. As I said earlier, "the code is working good, it hides & unhides rows....but NOT automatically."

At present I just create a button that I will click to start the hiding & unhiding process.