Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy Data from Row 1 to last blank row in next worksheet
I am in need some help I am currently using this macro to copy from cell A1
sheet1 to create a list on sheet2 - Private Sub Worksheet_Change(ByVal Target As Range) Dim LastRow As Long, ws As Worksheet If Not Target.Address = "$A$1" Then Exit Sub Set ws = Worksheets("sheet2") LastRow = ws.Cells(Rows.Count, "c").End(xlUp).Row ws.Range("c" & LastRow + 1).Value = Target.Value End Sub Works great for coping one cell. But how can i increase the copy area? I now need to copy sheet1 cells a1:n1 to the next blank row in sheet2 when ever sheet1 A1:N1 are changed. I could actaully use N1 as the triger if needed. Set up is an out side programm will be pasting data to sheet1 A1:N1 for each record, I need to then copy that row of information to create a list on another worksheet. Thanks to anyone that can help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy Data from Row 1 to last blank row in next worksheet
I think I'd try using
ws.Range("c" & LastRow + 1).EntireRow = Target.EntireRow -- HTH, Barb Reinhardt "MyKeyJ" wrote: I am in need some help I am currently using this macro to copy from cell A1 sheet1 to create a list on sheet2 - Private Sub Worksheet_Change(ByVal Target As Range) Dim LastRow As Long, ws As Worksheet If Not Target.Address = "$A$1" Then Exit Sub Set ws = Worksheets("sheet2") LastRow = ws.Cells(Rows.Count, "c").End(xlUp).Row ws.Range("c" & LastRow + 1).Value = Target.Value End Sub Works great for coping one cell. But how can i increase the copy area? I now need to copy sheet1 cells a1:n1 to the next blank row in sheet2 when ever sheet1 A1:N1 are changed. I could actaully use N1 as the triger if needed. Set up is an out side programm will be pasting data to sheet1 A1:N1 for each record, I need to then copy that row of information to create a list on another worksheet. Thanks to anyone that can help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy a formula into a blank column only to the last data row | Excel Worksheet Functions | |||
copy from B worksheet to A worksheet with NO repeated data | Excel Discussion (Misc queries) | |||
Where are the examples from Help to copy to a blank worksheet? | Excel Discussion (Misc queries) | |||
Macro copy and paste = blank worksheet | Excel Discussion (Misc queries) | |||
Copy rows of data to another worksheet where ReturnDate is blank | Excel Discussion (Misc queries) |