Solve : Excel Form Help?

1.	Solve : Excel Form Help?
Answer» Help! I own a small limousine company and would like to develop forms in Excel so that when clients call in I can easily type their information into the CONTRACT and have it nice and professional looking. How do I save my worksheet as a form and set cells up so that I can automatically enter text? If this rambling question is too big to answer in this setting, can you recommend a book or two for my reference library? Any help is greatly appreciated! Thanks! TimSee http://www.contextures.com/xluserform01.html. For more references, do a Google search on creating forms with excel. Access, MIGHT word equally well or better for this, depending on exactly what your requirements are. Cherokee, Excel has some severe limitations! I.E Cell reference from one Worksheet to the next. I agree with Soybean. In your case, I would use MicroSoft Access. It will give you lots of flexibility, and better results. It is easy to learn. Quote from: alexK on December 28, 2010, 12:02:06 PM Excel has some severe limitations! I.E Cell reference from one Worksheet to the next. What? You can reference cells in other worksheets and even entirely different files (workbooks). since some of the very earliest versions. C:\file.xls!Sheet2!A3 for example That being said what is being done here is the common trap of using a Excel spreadsheet to DEAL with database records. Access, or, depending on the scope of the APPLICATION, a even bigger DB product (SQL Server, MYSQL, Oracle) definitely would better manage the data better, they're designed for that very purpose after all.

Answer»

Help! I own a small limousine company and would like to develop forms in Excel so that when clients call in I can easily type their information into the CONTRACT and have it nice and professional looking. How do I save my worksheet as a form and set cells up so that I can automatically enter text? If this rambling question is too big to answer in this setting, can you recommend a book or two for my reference library? Any help is greatly appreciated! Thanks!

TimSee http://www.contextures.com/xluserform01.html. For more references, do a Google search on creating forms with excel. Access, MIGHT word equally well or better for this, depending on exactly what your requirements are. Cherokee,

Excel has some severe limitations! I.E Cell reference from one Worksheet to the next.
I agree with Soybean.
In your case, I would use MicroSoft Access. It will give you lots of flexibility, and better results. It is easy to learn. Quote from: alexK on December 28, 2010, 12:02:06 PM

Excel has some severe limitations! I.E Cell reference from one Worksheet to the next.

What? You can reference cells in other worksheets and even entirely different files (workbooks). since some of the very earliest versions.

C:\file.xls!Sheet2!A3 for example

That being said what is being done here is the common trap of using a Excel spreadsheet to DEAL with database records. Access, or, depending on the scope of the APPLICATION, a even bigger DB product (SQL Server, MYSQL, Oracle) definitely would better manage the data better, they're designed for that very purpose after all.

Solve : Excel Form Help?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment