making a form

J

Jeremy Beck

I have created a worksheet in Excel. It is very basic. I have added drop down lines and things such as that. I am looking to get more in depth. What I want to be able to do, is make the document a form so that i can tab between the fields. I also want to be able to eventually perform queries to track certain things within the the document. I woud love to be able to save all the forms as I enter them to be able to track them and perform the queries or be able to bring them up with I need to know what is going on with that customer. I am very basic in my excel knowledge. I want to be able to push a "clear" tab and clear the form instead of having to close it out and re-open it to use it again. Is all of this possible, or not. Please help.

Thanks -
 
J

Joe

Sounds like you need MS-Access for these tasks, but perhaps someone else knows how Excel might do this. Access will do these things.
 
J

Jeremy Beck

I know that MS-Access can do these things. The problem is that I do not have Access. Several people have told me that these things can be done in Excel as well, and I have the form in Excel. Hopefully someone can tell me how to do these things in Excel.
 
Top