| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I copy several rows from one sheet to another...
I am currently doing...
ActQty.Entirerow.Copy Destination:=Sheets(1).Cells(.Rows.Count, "A").End(xlUp).Offset(1,0) ....but the copied rows are copied to the bottom of the destination sheet. I want the copied rows to start at row 15 of the destination sheet, not the bottom. I also want just the data copied. I do not want the copied rows to wipe out my cell formatting on the destination sheet. Thanks! --- Posted via news://freenews.netfront.net/ - Complaints to --- |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I copy several rows from one sheet to another...
Answered in public.excel.programming
"Saucer Man" wrote in message ... I am currently doing... ActQty.Entirerow.Copy Destination:=Sheets(1).Cells(.Rows.Count, "A").End(xlUp).Offset(1,0) ...but the copied rows are copied to the bottom of the destination sheet. I want the copied rows to start at row 15 of the destination sheet, not the bottom. I also want just the data copied. I do not want the copied rows to wipe out my cell formatting on the destination sheet. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy rows to another sheet | Excel Programming | |||
| copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
| Copy rows onto existing sheet / start a new sheet if full | Excel Programming | |||
| Search for rows in one sheet and copy into another sheet based on customer id | Excel Worksheet Functions | |||
| Help: auto-copy entire rows from 1 sheet (based on cell criteria) to another sheet. | Excel Programming | |||
Linear Mode
