Hello I am looking for more experts since I did not get an answer yet in other forum but admit it is only 1 day
Hope I am doing this right
other post
https://www.mrexcel.com/board/thread.../#post-6170877

I am trying to modify a macro
I want it to maximize so that net income matches spending day to day. the Macro works great
Where I would like to automate it more is that now it will insert numbers in K even though the funds in T are depleted (red conditioning)
What I would like it to do is to look at column T and see if there are funds if yes insert calculated number from goalseek macro in K
If not write in K7 last funds left in this case 7119.64 from t6.
next 2 lines should be 0
then funds are OK so 6312 is correct

Thank-you