Solved: Copy to another sheet problem .

[parscon]

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

[Bob Phillips]

With Worksheets("Sheet2")

Worksheets("Sheet1").Range("A1").Copy _
.Range("A" & .UsedRange.Rows.Count.UsedRange.Cells(1, 1).Row - 1).Offset (1)
End With
Application.CutCopyMode = False

[raji2678]

As far as my understanding goes, you do not want to copy the blank columns. You can write a simple macro to check that the column is not blank.

[Bob Phillips]

As far as my understanding goes, you do not want to copy the blank columns. You can write a simple macro to check that the column is not blank.

My understanding is that he is overwriting rows that are blank in the first few columns because his last row finder is missing those blanks.

[parscon]

My understanding is that he is overwriting rows that are blank in the first few columns because his last row finder is missing those blanks.

yes , exactly and it is work now , thank you so much ..