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.
Bookmarks