Automate - Copy data between worksheets

My client wants me to setup an MS Excel workbook. This is kind of a strange setup, but see how this goes. I'm new to Excel. I usually only use MS Access for this.

1. The attached you will see has 2 worksheets. (form & data worksheet tabs)

2. The form tab will eventually have 12 pages worth of questions / with the data tab matching the same number of columns.

3. My client wants to use the form worksheet tab as kind of an "interface" with the data worksheet tab.

4. The user will enter the information in to the form worksheet tab, click some kind of button------> that will....

5. The data / typed in values in the form worksheet tab will be copied over to a new row in the data worksheet tab. - After copied over, all the data in the form tab would clear out to be ready for the next entry. They will eventually use all the records in the data worksheet tab just for other reporting information.


----When the data is copied over, the user should not see the data being copied over. To them, the form will just clear out & be ready for the next record.

Other features to add- add the top, I have two hyperlinks. (milk & fruit) I want 2 buttons instead taking you to the Milk Section & one taking you to the fruit section.

Why aren't we using the built in Excel data form ---- It doesn't look good, it will eventually be a long survey.

What do I need your help with - Only the above. The code must be open for me to add to it. I'm hoping / thinking I can finish up the rest on my own once I see what I am doing wrong.

Other Notes: This excel worksheet will be copied over / run on a PDA (HP iPAQ 210 Enterprise Handheld)

Deadline - ASAP / Tonight - Tomorrow Morning

I need this in Excel 2000, 2003, & 2007 version

Please email me price. (Pay by paypal) mjbressler@earthlink.net

Thanks for amending your title.

See if link get you started

http://www.contextures.com/xlUserForm01.html

VBA Noob

Think you would need a multipage userform. Try searching the web for examples

Also, have you ever had any problems / experience running excel on a handheld

This is not related to your first question. Please do read the forum rules below

VBA Noob