Hello everybody and thanks in advance for any help you can provide.
I am quite new with VBA so I am not sure how to even start with this. I know there are similar requests in the forum but I am not sure how to make those answers solve my problem. What I need is to use VBA to make the blue shapes (there will be much more than three shapes) in the picture below move and match the exact position in row 6 according to the start date (Column G) and end date (Column H) every time. The shapes should move and adjust their length every time I change a date in columns G or H, that should be the trigger.
Hope there is a solution for this because I am going crazy trying to solve it!
Thanks in advance.
I am quite new with VBA so I am not sure how to even start with this. I know there are similar requests in the forum but I am not sure how to make those answers solve my problem. What I need is to use VBA to make the blue shapes (there will be much more than three shapes) in the picture below move and match the exact position in row 6 according to the start date (Column G) and end date (Column H) every time. The shapes should move and adjust their length every time I change a date in columns G or H, that should be the trigger.
Hope there is a solution for this because I am going crazy trying to solve it!
Thanks in advance.
