Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy row to different worksheet
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy & paste cells fr open worksheet then close the worksheet | Excel Programming | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
copy range on every worksheet (diff names) to a master worksheet (to be created) | Excel Programming | |||
copy range on every worksheet (diff names) to a master worksheet (to be created) | Excel Programming | |||
Code to copy range vs Copy Entire Worksheet - can't figure it out | Excel Programming |