Octopill
07-12-2016, 09:47 AM
Hello everyone,
I have almost 0 experience with VBA, and after spending 1 hour on google I could'nt find any "plug-in" code that would work for me.
Basically what I need is code that would goal seek all the cells that have been selected by the user, match them with a fixed value (from a single cell), by changing the cells adjacent to the selection.
It looks like this :
Columa A =Initial Date
Column B = number of days between initial Date and Final Date
Colum C = Final Date (Intial Date + Days)
Cell E2 = GoalSeek value
So user would select any cell from column C (final date), and the macro would change adjacent cells in column B to set selection to the GoalSeek Value in E2. Ideally the macro could be linked to a button so the user select -> click button -> tadaa
I am attaching a file if that helps.
Thanks a lot for your help :)
I have almost 0 experience with VBA, and after spending 1 hour on google I could'nt find any "plug-in" code that would work for me.
Basically what I need is code that would goal seek all the cells that have been selected by the user, match them with a fixed value (from a single cell), by changing the cells adjacent to the selection.
It looks like this :
Columa A =Initial Date
Column B = number of days between initial Date and Final Date
Colum C = Final Date (Intial Date + Days)
Cell E2 = GoalSeek value
So user would select any cell from column C (final date), and the macro would change adjacent cells in column B to set selection to the GoalSeek Value in E2. Ideally the macro could be linked to a button so the user select -> click button -> tadaa
I am attaching a file if that helps.
Thanks a lot for your help :)