Hi,

I'm trying to build a survey form where you can choose things like door types, hinges, floor level etc. There are about twenty options. Each set of twenty questions needs a unique number to link it them together. It almost needs to look like an order form, the results of this would then populate a table and tells us what we need to order, how many hinges etc (not all twenty fields).

Currently we have twenty questions formatted in a single print screen and then repeated within the same tab a number of times. A second tab then draws the information together into a table. This is working but users have to scroll down each set of twenty questions and answer all of them each time when many of the answers would be the same, same floor level etc.

The purpose of this is to one show a site survey, what needs to be done and two tell us what to order.

Is Excel the way to go with this? I've been thinking of a spreadsheet with built in buttons, a modified version of what we have but rather than repeating the sets of questions just have one set and a "submit" type button which would populate a new row in a secondary tab / table each time it is clicked. But not sure how to achieve this as my VB skills are limited.
I've also wondered about creating something in Access or even online using Wordpress...any thoughts or suggestions?

It doesn't need to look amazing but does need to be functional, easy to use and low cost (preferably DIY)

Thanks