Create a data entry form

[Guest]

Hi, I want to create a data entry form which will allow tele operators to
have a finite and user friendly set of fields to enter data that will
populate an excel sheet and then make calculations that return in the form.
More specifically I would like fields for custoemr info, what they want to
buy then based on quantities and product types return the total to teh
operator. Is there a way to do this in excel?

Cheers,

- Douglas

 

[Guest]

Hi Douglas,

Yes it is possible. There is an excellent tutorial on data forms which you
can find at http://spreadsheets.about.com/cs/exceladvanced/a/vba1index.htm.

All the best!