Martin sherk
Board Regular
- Joined
- Sep 11, 2022
- Messages
- 94
- Office Version
- 365
- 2016
Hello,
I need help copying data from my current active workbook(Code is in another workbook) to a closed file
My current active worksheet which I will copy data from has the name "Customers Data" sheet
My destination path for the closed workbook is C:\1.Martin\1.Work\Customers\October 2022
My destination workbook is: Customer Raw data.xlsx
My destination worksheet is: Customers Data
Can someone help construct a VBA to do the above, I will be thankful.
I need help copying data from my current active workbook(Code is in another workbook) to a closed file
My current active worksheet which I will copy data from has the name "Customers Data" sheet
My destination path for the closed workbook is C:\1.Martin\1.Work\Customers\October 2022
My destination workbook is: Customer Raw data.xlsx
My destination worksheet is: Customers Data
Can someone help construct a VBA to do the above, I will be thankful.