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

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.

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

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_Us...Excel/629.html
http://www.ozgrid.com/VBA/UserForms.htm


HTH,
JP

On May 12, 2:16*pm, SSW wrote:
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.

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

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

"JP" wrote:

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_Us...Excel/629.html
http://www.ozgrid.com/VBA/UserForms.htm


HTH,
JP

On May 12, 2:16 pm, SSW wrote:
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.

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

Care to share?

--JP

On May 28, 3:23*pm, SSW wrote:
Thanks JP - I've got this one figured out.



"JP" wrote:
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_Us...Excel/629.html
http://www.ozgrid.com/VBA/UserForms.htm

HTH,
JP

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

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

"JP" wrote:

Care to share?

--JP

On May 28, 3:23 pm, SSW wrote:
Thanks JP - I've got this one figured out.



"JP" wrote:
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_Us...Excel/629.html
http://www.ozgrid.com/VBA/UserForms.htm

HTH,
JP