Input form in excel

  • Thread starter Thread starter Fawn
  • Start date Start date
F

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
 
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
Click to expand...


____________________________________________________________________________
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
______________________________________________________________________________________
 
Back
Top