Ok so I've done a few searches and couldn't find what I was trying to do.
What I want to do is have a formula that at the first of the month adds, lets say, 3.5 to that particular cell. Then at the beginning of the next month it would add in another 3.5 and would display 7.0 without me having to input it myself.
I would also need it to take away a total of a row on another worksheet within the workbook itself.
I found this article : http://support.microsoft.com/kb/213445 , Which tells me how to do a OnEntry macro for a cell but I have to input the number myself and not sure how to take away a total from another worksheet.
I'm slightly above novice level I would say but know nothing about excel programming or macros.
Thank You
Bookmarks