Create a data entry form
 

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

Create a data entry form
 

Hi Douglas,

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

All the best!

"Douglas" wrote:

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