| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Row 2 from Sheet1 & Paste to Row 10 Sheet2
How can I copy Row 2 from Sheet1 & paste to Row 10 Sheet2, if Sheet2 Row20 is
blank, and if it is not blank, paste to the next blank row in Sheet2? I have an idea of how to copy form 1 and paste to 2, in the first blank row in 2: Worksheets("Sheet1").Range("2:2").EntireRow.Copy Worksheets("Sheet2").Range("A65536").End(xlUp)(2). EntireRow However, I can't figure out how to test if Sheet2, Row10 is blank, and if it is blank, paste there, but if it is not blank, paste in the first blank row on Sheet 2. Regards, Ryan--- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy from sheet1 then paste special transpose to sheet2,3,4 | Excel Discussion (Misc queries) | |||
| copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
| Macro to Copy data from a list in sheet1 and paste into sheet2 | Excel Discussion (Misc queries) | |||
| multiple search criteria to find and copy from sheet1 and paste into sheet2 | Excel Programming | |||
| Search, find, copy from sheet1 and paste into sheet2 | Excel Programming | |||
Threaded Mode
