donatepresent
New Member
- Joined
- Oct 4, 2017
- Messages
- 21
Hi Everyone,
I need help figuring out how to copy a fixed data range from another Workbook with a fixed file name (i.e. COA.xlms) and paste to the current/master/active Workbook that does not have a fixed file name(dynamic). Both Workbook will already be open, but the problem for me is how to get the copied data back to the current/master/active Workbook that the VBA is running on.
Thanks,
Ken
I need help figuring out how to copy a fixed data range from another Workbook with a fixed file name (i.e. COA.xlms) and paste to the current/master/active Workbook that does not have a fixed file name(dynamic). Both Workbook will already be open, but the problem for me is how to get the copied data back to the current/master/active Workbook that the VBA is running on.
Thanks,
Ken