Move multiple shapes wrt dates using VBA

[Lazybookwarm]

I got data as mentioned below in excel. All the activities are split in two different periods. For each such period I have to create a shape and place it according to its date and duration along the same row. e.g. in the below mentioned table for activity A, I will create two rectangular shapes and I want to place the first shape in the January-17 column (1st Jan to 5th Jan-17) and the second shape in the same January-17 column from 8th Jan-17 to 9th Jan-17. Both these shape shall resize themselves according to their assigned duration. Please let me know ways to do it using VBA or by other methods in excel. Thank you!

Activity

Dur (days)

Start

Finish

Dur (days)

Start

Finish

Jan-17

Feb-17

Mar-17

Apr-17

May-17

Jun-17

A

5

1/1/17

5/1/17

2

8/1/17

9/1/17

B

6

6/1/17

11/1/17

4

2/4/17

5/4/17

C

7

12/1/17

18/1/17

6

8/5/17

13/5/17

D

8

19/1/17

26/1/17

8

7/2/17

14/2/17

E

9

27/1/17

4/2/17

10

19/2/17

28/2/17

<tbody>
</tbody>

 

[Lazybookwarm]

Hi guys,

Can anyone help me on this?

Thank you!