Hi all, i'm hoping someone can help me write a little code to perform the below action?
So, I have 2 workbooks. I need to copy cells A-E from the active sheet to a closed workbook and paste the values in to the first sheet (named Original Order) from cell A1.
The destination workbook resides in different locations so I need to be prompted to open the file. I also need this file to remain open so a copy can be saved in a shared folder.
Is this something that can be done?
I'm overhauling some processes for work so I might be back with a few more questions
Thanks in advance
Tom
So, I have 2 workbooks. I need to copy cells A-E from the active sheet to a closed workbook and paste the values in to the first sheet (named Original Order) from cell A1.
The destination workbook resides in different locations so I need to be prompted to open the file. I also need this file to remain open so a copy can be saved in a shared folder.
Is this something that can be done?
I'm overhauling some processes for work so I might be back with a few more questions
Thanks in advance
Tom