Copy Data from my current active workbook to a closed workbook

[Martin sherk]

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.

 

[dmt32]

code works ok for me not too sure at moment why you have an issue - if can place a copy of your workbooks with dummy data on a file sharing site like dropbox & provide a link to it - will have a look when can. Meantime, suggest you return to original version which stated performed ok

Dave