Data copy from a seperate sheet to data sheet
 

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

--
ZeroXev
-----------------------------------------------------------------------
ZeroXevo's Profile: http://www.excelforum.com/member.php...fo&userid=2444
View this thread: http://www.excelforum.com/showthread.php?threadid=38046

Data copy from a seperate sheet to data sheet
 

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


"ZeroXevo" wrote in
message ...

hi,

I am very new to VBA Macro in Excel. I was wondering if anyone can
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 seperate
worksheet and change row so that more data from the "form" worksheet
can be entered.

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

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

Thanks!! Cheerio
ZeroXEvo


--
ZeroXevo
------------------------------------------------------------------------
ZeroXevo's Profile:
http://www.excelforum.com/member.php...o&userid=24447
View this thread: http://www.excelforum.com/showthread...hreadid=380460