How to create a form on one sheet that enters data into another

[SSW]

Hi - new to VBE & macros, otherwise comfortable with Excel.
I'd like to create a form on sheet1, which will resemble a paper form that
is used to gather info. I'd like for this info to be entered into a row on
sheet2, and eventually have some totals and other summary info calculated.
And it'd be great if the operator can click a button for a report - tabular
or even graphic. Would like all this to be as automatic as possible.
Thanks.

 

[JP]

Have you checked out UserForms? There are many tutorial pages
available and it would be better if you started coding one yourself
and then came back with a specific problem, rather than simply asking
someone to provide the code for you.

http://www.contextures.com/xlUserForm01.html
http://www.exceltip.com/st/Create_User_Forms_in_Microsoft_Excel/629.html
http://www.ozgrid.com/VBA/UserForms.htm


HTH,
JP

 

[SSW]

Thanks JP - I've got this one figured out.

Have you checked out UserForms? There are many tutorial pages
available and it would be better if you started coding one yourself
and then came back with a specific problem, rather than simply asking
someone to provide the code for you.

http://www.contextures.com/xlUserForm01.html
http://www.exceltip.com/st/Create_User_Forms_in_Microsoft_Excel/629.html
http://www.ozgrid.com/VBA/UserForms.htm


HTH,
JP

 

[JP]

Care to share?

--JP

Thanks JP - I've got this one figured out.

 

[SSW]

Sure.
I searched web and found a link to a site by Ron DeBruin. He has an example
macro that pastes into the next empty row - I couldn't figure out how to do
that.
This gave me enough of a start to figure the rest out.
www.rondebruin.nl/copy1.htm
Thanks again,
SSW