ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copy data (https://www.excelbanter.com/excel-programming/308234-copy-data.html)

dan

Copy data
 
I use the folowing code in a macro to copy info from one
page to the next in the first available slot so I can keep
an ongoing count. How can I get it to not post before a
certain cell as well. In this case A26.

Sheets("Daily").Select
Range("b26:z4933").Copy _
Destination:=Worksheets("sheet2").Cells(Rows.Count ,
1).End(xlUp)(2)

dan

Copy data---never mind got it
 

-----Original Message-----
I use the folowing code in a macro to copy info from one
page to the next in the first available slot so I can

keep
an ongoing count. How can I get it to not post before a
certain cell as well. In this case A26.

Sheets("Daily").Select
Range("b26:z4933").Copy _
Destination:=Worksheets("sheet2").Cells(Rows.Count ,
1).End(xlUp)(2)
.



All times are GMT +1. The time now is 12:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com