Help (please, please) copying and pasting issue

D

Donna

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

pikus

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("Sheet1").Cells(newRow, 1
 
D

Donna

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
 
Top