Help (please, please) copying and pasting issue
First a special thank you to whoever reads and especially responds to
this post. I have been vainly trying for over a week to copy and paste data from one workbook into another. I have researched MVP Excel's site and and pulled the GetLastCell macros into the destination sheet. I am using the edit goto formulas command to locate my source data and then I am copying/pasting the vaules into the destination sheet. But each and every $%$# time I relaunch the macro to try APPEND data to the destination sheet, my existing data is overwritten. Does anyone out there have any ideas. I will be forever in your debt. A frustrated blonde.... |
Help (please, please) copying and pasting issue
Hi Donna
Try http://www.rondebruin.nl/copy1.htm I think you are looking for the last example http://www.rondebruin.nl/copy1.htm#workbook You need the two functions also -- Regards Ron de Bruin http://www.rondebruin.nl "Donna" wrote in message om... First a special thank you to whoever reads and especially responds to this post. I have been vainly trying for over a week to copy and paste data from one workbook into another. I have researched MVP Excel's site and and pulled the GetLastCell macros into the destination sheet. I am using the edit goto formulas command to locate my source data and then I am copying/pasting the vaules into the destination sheet. But each and every $%$# time I relaunch the macro to try APPEND data to the destination sheet, my existing data is overwritten. Does anyone out there have any ideas. I will be forever in your debt. A frustrated blonde.... |
Help (please, please) copying and pasting issue
Take a look at this and see if you can modify it to suit your needs. I
you need more help I'll need more info I think. - Pikus newRow = Worksheets("Sheet2").UsedRange.Row Worksheets("Sheet2").UsedRange.Rows.Count Workbooks("CopyFrom").Worksheets("Sheet1").Range(" A1:F1").Cop destination:=Workbooks("CopyTo").Worksheets("Sheet 1").Cells(newRow, 1 -- Message posted from http://www.ExcelForum.com |
Help (please, please) copying and pasting issue
Regarding the last post...does this macro know to go the last active
row? Also can I use it with Paste special as well? PS: Thank you so much for all of your help |
All times are GMT +1. The time now is 08:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com