View Single Post
 
Old 09-20-2020, 12:43 PM
NoSparks NoSparks is offline Windows 10 Office 2010
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

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
File Type: xlsm Circular ref problem_vba.xlsm (22.0 KB, 6 views)
Reply With Quote