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....

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....

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

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