GOALSeek for VBA

Hi Guys,


I hope you can help

I am preparing a cash forecast by week with the target value of ending up each week with 200k. I can do this on excel although one week at the time

Can anyone help me out with VBA in creating the code for GOALSEEK for multiple cells please


I have attached the excel file; row 42 target needs to be 200k, the changing cells range is row 31. Everything else is fixed

Thanks
V

Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
  
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.