[SOLVED] macro for Text Generator based of fields

[adamheon]

I am trying to create a macro to apply to a button that will automatically generate 1 line of text from multiple lines.

so to try and better explain this, i will have several options that need to be either selected from a drop down or entered as text (or #). Then i want to combine all that information and have it become 1 line of text.

example:

question 1 - xyz
question 2 - abc
question 3 - 123

click generate button

specific cell = xyz, abc - 123

attached is the actual information and additional notes in red that i would like to see. hopefully this helps. any help would be much appreciated!! EXAMPLE.xlsxEXAMPLE.xlsx