create multi-field, with layout, user questionnaire to save reply.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm creating a questionnaire to send to vendors. My target software imports
csv files. I want my questionnaire in Excel but I don't want a really long
row of headings with data in cells beneath - it doesn't serve us well in that
layout. I'd like to create a layout in which I can select specific cells for
the field ID with the cell beneath it as the one to be exported. Basically,
I want a regular worksheet function in a non-linear layout. Is that
possible? How? I'm pretty quick on the uptake - very trainable :)
 
Maybe you could use 3 columns (or more).

Column A: Question number
B: Description
C: Response

Row 1 would contain the version number of your questionnaire so that you know
how to parse the data and what the questions mean(??).

So you'd have to change the way you import the results or change the way you
save the results (or probably both!).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a questionnaire..... 2
Worksheet automatically saves itself after data is inputted in cel 6
Creating a Required Field 2
Possible to import Word forms en masse into Excel spreadsheet? 2
Comments to help Users 1
Using VBA to change Excel layouts 2
Is it possible to hide column headings & row numbers? 2
Copy data from one worksheet to another 5

Back
Top