Hi

Apologies for the long post!! I had an idea for work (i work in a business change function) which I am really keen on implementing, but don't quite know how to get there.

Essentially I have a page set up with a project end date and a series of headings, each heading representing a team in our department. Under each heading is a series of questions. For example, under one heading there is a question about whether the project you are working on requires communication to end users. If you select the "yes" option button, a hidden row appears and lists all the types of communication available.

So far so good.

My issue is that for each answer that is selected, I would like a gantt chart to be built in the background, but have no idea how to achieve this. Essentially as the project end date is known at this point i would like each task to work backwards from that fixed point. ie project end date is 01/10/2012 and I need a communication out which i know needs to be submited 5 working days before launch and will take another week to write, circulate and get sign off for. So the date on the auotmatically build Gantt, needs to be 01/10/2012 minus 10 working days (or 14 calendar days) prior.

There is a strong possibility that having answered all the questions the start date for the project would need to be in the past, so it would also need to ignore this fact and keep going.

like I said apologes for the long post, but if anyone has a clue where to start I would be really grateful!