I have a macro that records / takes the file name from a D1 cell, this works ok.
The question is how can I copy the data from sheet1 in its entirety and pass it to a new sheet in another book. (Text in D1 change every week)
I have a macro that records / takes the file name from a D1 cell, this works ok.
The question is how can I copy the data from sheet1 in its entirety and pass it to a new sheet in another book. (Text in D1 change every week)
Perhaps post the code you already have ( don't forget to wrap the code with tags (#button))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks