Hi All,
I am hoping to find a way to create a new worksheet using the text "Kansas- OJR" followed by the current date mmddyyyy as the filename. I currently have a button on the tab "KS OJR" that is called Copy Sheet. My hope is to use that button to Copy the sheet and then create a new sheet using the naming criteria above and paste the data that was copied into the new sheet.
Thank you in advance for any help!
Adam
Try
Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Is there a way to have this script create a new spreadsheet using the name criteria and not just add a new tab?
Thank you,
Adam
You mean a new workbook? And a workbook per day?
Sorry, I was hoping for a new workbook per day. Or better phrased, a new workbook when the button is clicked. That should only be once a day.
250 + books in a year ??? Let's hope you never need to do any processing which requires looking at several weeks' worth of books.
Code is in sheet "KS OJR". there is no check to see if workbook already exists so running more than once a day will overwrite the existing onePlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks