parscon
02-23-2012, 03:46 AM
I have A-B-C-D-E-F-G-H-I-J column , but for some row i do not have any data on column A-B-C-D in sheet A, just i have data on cloum E-F ... , when use this code it , shopy all data to another sheet
in second sheet column for some row i do not have any data on column A-B-C-D but when use another data it will repleace with this , it will not copy to another row .
Worksheets("Sheet1").Range("A1").Copy _
Worksheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1)
Application.CutCopyMode = False
in second sheet column for some row i do not have any data on column A-B-C-D but when use another data it will repleace with this , it will not copy to another row .
Worksheets("Sheet1").Range("A1").Copy _
Worksheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1)
Application.CutCopyMode = False