Can anybody help me about VBA code? I attached here one files and one screenshots. “63 Current OLD” file is source and main file, “63 New May” file is destination file. Anyway, “63 Current OLD” file had sheets 10021, 10022, 10023, 10024, 10025 and already copied to , “63 New May” file. Today, “63 Current OLD” file have sheets 10026 to 10032 I want to copy to “63 New May” file. Tomorrow maybe sheets will create 10033 to 10040, day after tomorrow maybe create sheets 10041 to 10050. So, during the current (May) month different days sheets I want to copy to “63 New May” file.
Next month create a new file which name will be “63 New June”. After next month new file which name will be “63 New July” etc., So, every month sheets will copy to new file many times and every month new file’s name will change. In this situations what will be code? I am not expert in VBA code. Please, help me if you can and wish.
Thank you for your time!!!
Bookmarks