I wish to copy selected data to the workbook that contains the original Coding. So, for example, Workbook 1 contains a macro that manipulates the data in Workbook2, then I want to copy the data back to WorkBook1. Here is my failed attempt. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o></o>
'Copying Data from Workbook2 <o></o>
Rows("2:2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
'Pasting Data to Workbook 1 that contains code. <o></o>
ThisWorkbook.Sheets("Data").Range ("A1") 'where the code is failing
Range("A65536").End(xlUp).Offset(1, 0).Select
ActiveSheet.Paste<o></o>
<o></o>
Note: Workbook1's file name is constantly changing so I don't want to reference "Workbook1" directly but rather the workbook running the code. <o></o>
<o></o>
I hope it’s not confusing. <o></o>
<o></o>
Thanks, <o></o>
fficeffice" /><o></o><o
></o>'Copying Data from Workbook2 <o
></o>Rows("2:2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
'Pasting Data to Workbook 1 that contains code. <o
></o>ThisWorkbook.Sheets("Data").Range ("A1") 'where the code is failing
Range("A65536").End(xlUp).Offset(1, 0).Select
ActiveSheet.Paste<o
></o><o
></o>Note: Workbook1's file name is constantly changing so I don't want to reference "Workbook1" directly but rather the workbook running the code. <o
></o><o
></o>I hope it’s not confusing. <o
></o><o
></o>Thanks, <o
></o>
