Looking for an Excel front end for data entry

[rock]

Hi,

I am looking for a front end to Excel that allows someone who is not
computer literate to still be able to enter data.

Like a form I guess where the filed or column is shown and they just
fill in the text, then go to the next col as opposed to doing it in a
spreadsheet way.

I have looked at the Excel Form option but I need something a little
more than that.

Thanks

rock

 

[Kurt Heisler]

If Microsoft Access is an option, I would recommend using that
instead. Access provides much more flexibility than Excel with
building a data entry form. The data are entered in a form you create,
and stored in a table that the user never has to interact with.

 

[(PeteCresswell)]

Per Kurt Heisler:

If Microsoft Access is an option, I would recommend using that
instead. Access provides much more flexibility than Excel with
building a data entry form. The data are entered in a form you create,
and stored in a table that the user never has to interact with.

x2 for MS Access - but if you are going it alone, the learning
curve may rule it out.

 

[rock]

Per Kurt Heisler:

x2 for MS Access - but if you are going it alone, the learning
curve may rule it out.

Yes Home Alone I'm afraid.. and no time to learn anything, to boot..

Thanks guys,

rock

 

[Nick Vivian]

Hi,

I am looking for a front end to Excel that allows someone who is not
computer literate to still be able to enter data.

Like a form I guess where the filed or column is shown and they just
fill in the text, then go to the next col as opposed to doing it in a
spreadsheet way.

I have looked at the Excel Form option but I need something a little
more than that.

Thanks

rock

hi Rock
I wrote a little share trading system that does something similar...
Take a look, feel free to modify it for your own needs.

http://excelexperts.com/Share-Trading-System

Nick
Founder
http://excelexperts.com