Thread
:
How can I accumulate a value in a given cell without creating a circular reference?
View Single Post
09-20-2020, 12:43 PM
NoSparks
Windows 10
Office 2010
Excel Hobbyist
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
Have a look at this VBA solution.
Just type number in E33 and it will add to D33 every time
until you enter a new date in B34 then it will be E34 that adds to D34.
It will always apply to the last used row according to column B.
Attached Files
Circular ref problem_vba.xlsm
(22.0 KB, 6 views)
NoSparks
View Public Profile
Find all posts by NoSparks