Data copy from a seperate sheet to data sheet

[ZeroXevo]

hi,

I am very new to VBA Macro in Excel. I was wondering if anyone ca
point me in the right direction to how to create a macro to:

A form-like worksheet as the data entry with indirect cell dependency
(droplists)
I need a macro to be able to copy the entered data into a seperat
worksheet and change row so that more data from the "form" workshee
can be entered.

I think another macro to reset my 'Form" worksheet.

Are these easily achieveable? Or need really advanced VBA programming?

Thanks!! Cheerio
ZeroXEv

 

[Anne Troy]

Here's a sample. See if you can use the code to emulate what you need:
http://www.myexpertsonline.com/freedls/invoices.xls
Hope it helps!
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com