View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SSW SSW is offline
external usenet poster
 
Posts: 3
Default 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.