Copy row to different worksheet

  • Thread starter Thread starter PamG
  • Start date Start date
P

PamG

I want to copy a row of data in one worksheet (Wkst 1) to the first blank row
in another worksheet (Wkst 2). The problem is that Wkst 2 has an additional
column as column 1, so I want to copy the row (which starts on column A) in
Wkst 1 to Wkst 2 starting at column B.


If IsError(Application.Match(CStr(R.Value), V, 0)) = True Then
R.EntireRow.Copy Sheets("Issues").Range("B65536").End(xlUp) (2)
.EntireRow.PasteSpecial Paste:=xlPasteValues


This code copies to Wkst 2, but to column A, not column B!

Please help!

Thanks
Pam
 
You are copying and pasting the entire row so you can not define the column
as you are working with all of the columns in that row.
 
Pam
Copy just the occupied cells in that row instead of the whole row, then
paste to one cell in Column B of the other sheet. HTH Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WorkSheet or AutoFilter Problem 4
The Information cannot be pasted Message 3
Messing Up on AutoFit 6
Copy the first row to other sheets. 1
fill data 1
Need Help with AutoFit and Blank(Null) Cells 3
Copy Rows To desinated Sheet Please. But First Creating Them. 3
Match (Fucntion, Script, or Macro) 5

Back
Top