Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy to different worksheets on next row
Hello,
Im kind of new to VBA. What little code I do know is just enough to be dangerous when I try doing something I dont understand, so any help you could provide would be greatly appreciated. The short description of what I am trying to do is with Excel 2003 I am trying to automatically copy data from one worksheet to the next empty row on one of the other worksheets depending on the type of information. Heres the detailed description: I have 4 different worksheets in the same workbook: Screening, Guided, Toolkit, and Control. The Screening worksheet is where all of the data is initially entered. I am trying to get the information in Screening cells A2:D2 to copy to cells A2:D2 of the corresponding worksheets depending on if the data typed into Screening cell K2 is guided, toolkit, or control. This would be done for multiple rows of information entered into the Screening worksheet so I am also trying to get the data to simply fill into the next empty row on the correct worksheet. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i copy a cell in worksheets 10 to the other 9 worksheets | New Users to Excel | |||
Copy Worksheets | Excel Worksheet Functions | |||
Copy Worksheets | Excel Programming | |||
copy between worksheets does not copy formulae just values | Excel Discussion (Misc queries) | |||
Copy between worksheets... | Excel Worksheet Functions |