Input form in excel

[Fawn]

Is there a way to create a permanent input form in excel to enter data and
have the data recap to a master data sheet.

I need to create an input form so that the users can input in fields without
any issues of which line they are inputting on.

What I need this one to do is if it is a Sale it populates questions that
need to be answered if it is a referral a different set of questions will
appear.

The users do not like access so that is why I need to create this in excel.

thanks

 

[Harald Staff]

Hi

See if John W's data form does the job:
http://spreadsheetpage.com/index.php/dataform/home

HTH. Best wishes Harald

 

[gotfredMX]

Is there a way to create a permanent input form in excel to enter data and
have the data recap to a master data sheet.

I need to create an input form so that the users can input in fields without
any issues of which line they are inputting on.

What I need this one to do is if it is a Sale it populates questions that
need to be answered if it is a referral a different set of questions will
appear.

The users do not like access so that is why I need to create this in excel.

thanks

____________________________________________________________________________
You may solve it by allowing iteration and IF(),
use one cell to enter data after you write them. Make coulumn A: a
growing number


write this if function in one cell and drag it into all following.
you need to chance the counter to next row befor you enter new
data. (reset = 0 delete all data again)

A B
3 Counter
1 Reset
Datavalue 3

result
1 98 B6=IF(reset=0;"";IF(A6=counter;Datavalue;B6))
2 32
3 35
4
5
6
______________________________________________________________________________________