I have 2 workbooks (see attached) that i am using a button in wb1 to copy a range of cells based on the active cell and paste all formatting and values to the next available row in wb2.
I first tested my code to do this action in the same workbook and worked great. That code is available in the attached file (Master Production Schedule) under Module 2. I was able to use the Copy Destination:= in the same workbook, but that fails when opening a new workbook so I changed it to use the PasteSpecial option. Can someone help me fix this.Master Production Schedule.3.8.13 Test2.xlsmMaster PS Results 2013.xlsx
The code i have below does the following
1. Opens the closed workbook
2. Checks to see if it is read only
3. Copies my range based on the active cell
4. Pastes an Image at the next available row (i want to fill the next available row)
5. Saves wb2 and closes it
6. Reactivates wb1
7. Deletes the Line that was transferred
8. Performs some additional code to keep the existing table with the same # of rows.
Bookmarks