Creating an Action List from a Gantt Chart

[jimmybangs]

Hi,

I have a Gantt Chart that I use for showing me what actions occur on what date (example of which provided below).

http://flic.kr/p/8pszXs

I would like to create a macro to change this Gantt into an ordered action list, (example of which is shown below), I have tried to create this with a PivotTable and failed...

http://flic.kr/p/8ppPMM

Anybody got any ideas of how to do this?

James

P.s. Apologies for not including the images as images - the Picture thing wouldn't work