Spreadsheet - output choices

[zombieromero]

Hi,

I'm wondering if someone can point me in the right direction or offer some advice. I am looking to create a spreadsheet wherein the user can choose multiple drop downs in sequence and then have it output each choice to a template or empty space within the spreadsheet.

Fo example, lets say column 1 said what is your favourite colour and had a dropdown with two choices red and green. Column 2 says "favourite place" and had a drop down with two choices "London and USA". Then once the user chooses an answer in each column it would output these choices to notepad or a large space within the spreedsheet. In this example it would output:

"Red
London"

if the first two answers were chosen from each column. Obviously it would be a much larger scale than the simple example above. Can someone give me some advice on this?

Many thanks.

[Mazzaropi]

zombieromero, Good morning.

Take a look on this example I did for you.
14-03-2014_ExcelForum_Printing_Big_Texts.xls

Please, tell us if is it what you want.
I hope it helps.