Hi all
Basically say i have a value in A1 of 100, and in B1 i have a value of 50, and in c1 i have a date, lets say 1st August.
What i want excel to do is when it reaches the 1st of august i want the value of B1 to add into A1 (making A1=150) then the value and date from b1 and c1 to be deleted.
Is this possible?
I am not very good with VBA at all, but i can throw a makro together sometimes by using the record feature !
Thanks for any help on this
Chris
Bookmarks