''Copies data from Column D & E to the next Row. ''Copies data from Column C to the next Row. 'Copies data from Column B to the next Row. 'Comment out any columns you do not wish to be copied down to the next row. ![]() 'setup to extablish column A as the Target Column to trigger the routine Private Sub Worksheet_Change(ByVal Target As Range) Obviously you can tell I'm a newbie at VBA - but I'm just starting to learn. I tried deleting the 1st End Sub line - but that didn't work. How do I do it? I tried just copy/pasting one under the other and it said the "Worksheet_Change" name was already use (or something like that) then I tried changing the "Worksheet_Change" name to "Worksheet_Change2" - then it gave me an error saying that nothing can come after an End Sub. I need to run both of these on one sheet. The next allows my users to select multiple items from my data validation list. ![]() Hi - Using Excel 2007 - I have found two very useful VBA codes (shown below) the 1st copies all my data validation from one row to the next each time a user enters something in cell A1.
0 Comments
Leave a Reply. |