Pre fill a letter with selected answers from excel

Hi all,

I cant find anything on how to do this so apologies if it already exists.

I want to have a series of about 10 questions in excel that you select the answer from a drop down, I then want depending on each answer it to pre-fill a draft letter in word or excel.

does anyone have a template of anything like this that i could have and alter to my own? or could anyone help?

Look forward to your repsonse,

Regards

Joe

Nick's picture

looks like you need a little

looks like you need a little system...
basically what you need is to create a formula with standard text and link the result of the dropdown to create the whole text..
we'd be happy to provide a quote:
http://www.excelexperts.com/contact