Morning all, i'm looking to have a code that will copy the selected range into a new excel workbook and then save that with a file name and the days date.
Could anyone help me please. thanks
Morning all, i'm looking to have a code that will copy the selected range into a new excel workbook and then save that with a file name and the days date.
Could anyone help me please. thanks
Perhaps...
Please Login or Register to view this content.
Last edited by sintek; 01-24-2018 at 03:57 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
............................
This works but i need it to save the data as it appears as it is currently moving the formulas from the main sheet over to the new save.
Is there a way to have it copy the data as it appears in the original sheet over to the new save
also need to include this section to select the area i want to save in a new document
Please Login or Register to view this content.
Not sure what you are trying to copy...perhaps you should upload a sample...
Please Login or Register to view this content.
Thanks for your help, this has worked and helped greatly. Solved
Glad you got it sorted...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks