Excel Data Entry Forms (Data, Worksheet)

[Guest]

Folks:


I have a small Excel 2003 spreadsheet that I use for data entry purposes
each day.
The first half is used for data entry and the second half does calculations.

I would like to create a data entry form - data form or worksheet form.

* I am looking for an excel webinar or tutorial (audio/video/text) that
can explain the forms production process ?
* Is there a way to highlight the rows & columns of my already-existing
spreadsheet & "automatically" generate at least the data form ?



Thanks,
Jo

 

[Toppers]

Take a look here:

http://www.contextures.com/xlUserForm01.html

 

[Gord Dibben]

Excel has a data entry form at Data>Form that may provide what you need.

Select your range of data and Data>Form.


Gord Dibben MS Excel MVP

 

[Ron de Bruin]

And one that is much better from John Walkenbach
http://www.j-walk.com/ss/dataform/index.htm