How do I create a form in Excel without doing any heavy duty programming?

Question

I have a nice Excel sheet with information that I input on a daily basis. Besides using Microsoft Access, how can I create a form where you can type in the information (with some pull-down menus) and it would automatically input the information from my form to the spreadsheet?

In other words, I want a simple interface "form" instead of going row-by-row inputting my information.

Thanks!

P.S. - If anyone knows of a thrid party vendor that creates forms that I connect to my Excel sheet, I would appreciate your answers.

Answer 1

Take a look at Data/validation menu. It have some of the things you are looking for. Access is still best for entering data using forms.

Answer 2

In a a hundred 365 days's time little doubt the US would be denying the viscious hate marketing campaign it is presently waging against Latino immigrants. purely because it has forgotten it fairly is marketing campaign against Jews and the Irish. Do you think of for one 2nd that the reality which you would be able to coach that those signs and indicators weren't synthetic can coach that this sort of racial discrimination became into not rampant? The signs and indicators could have been handwritten, purely as they have been interior the Fifties in London and Liverpool. Do you relatively need to disclaim that each immigrant race that attempted to make a existence interior the US did not face the main astounding opposition from people who have been given there first? Are you going to disclaim that the Jews who tried to make a existence interior the US after WW1 and before the Holocaust became into made public wre not persecuted? in case you human beings fairly need to fool yourselves which you are the main welcoming race interior the international to immigrants, bypass seem at Yahoo - Immigration and spot the dislike filled spittle that spews out of your fellow countyrmen's mouths. EDIT exciting which you took the time to remark on my respond - yet not with information. Why not? do you're able to hit upon the costs of a few extra maudlin professors with poorly researched papers to attempt to justify your conceal up of history?

Answer 3

Access is the best for that but since you don't want to use it then I don't know any other ones.