•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to allocate savings goals, once a bucket hits max, re-allocate remaining funds?
Hi all,
I'm currently trying to bump up my savings to 6+ months of expenses. I'm trying to hit my goal in each category, that is automatically allocated per the percentage in column B across the board as deposits are made into C12.
However, once the value in E reaches 100%, I'd like to stop allocating to that specific bucket (oil is close) and distribute by the percentage for all categories not at 100% in E, by the percentage in column B across the remaining rows.
How would that be done? (I know, puke pizza for a lot of you. I like keeping it color coordinated.) :)
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#savings goals
#allocation
#bucket
#expenses
#percentage
#deposits
#categories
#100%
#distribute
#color coordinated
#C12
#remaining funds
#goal
#max