| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
| Copy data into new line on seperate sheet? | Excel Discussion (Misc queries) | |||
| flowing data to seperate sheet | Excel Discussion (Misc queries) | |||
| Does anyone know how I can seperate a post code in my data sheet? | Excel Discussion (Misc queries) | |||
| Print data in each row on a seperate sheet template | Excel Discussion (Misc queries) | |||
Linear Mode
