I want to copy a portion (A1:F54) of my current worksheet that I am working on, over to another workbook, that is not open. I want to use a button to do this. I am sure VBA is necessary and there would probably need to be a call to open the other workbook. There might also be another obstacle : the workbook that is to be copied to is in a shared online folder.
Any assistance in this issue would be greatly appreciated. Any time that you have taken to read or investigate into this question is greatly appreciated.