Copy Sheet into a New Workbook and Save it & Current Date
Рет қаралды 10,088
2 жыл бұрынHow to Copy a Sheet from the ActiveWorkbook in the New and Save the New Workbook in the related folder with Current Date.
To do it you will do following using VBA:
1 Open the New Workbook
2 Copy Active Sheet into the New Workbook
3 ReName this Sheet in the New Workbook
4 Cancel the default Sheet1 from the New Workbook
5 Give the Name to the New Workbook with the Current Date
6 Save the New Workbook in the related folder
7 Receive the message: "This Workbook is saved with the name:
Name & Current Date"
My Links:
🔴KZfaq: / myexcellife
🔴Pinterest: www.pinterest.es/jekasama/
🔴Twitter: / jeka_sama
🔴Instagram: / my_excel_life
Thank You for Visiting my Channel ❤️
#MyExcelLife #ExcelTutorials #exceltips #excel @MyExcelLife
@eleonoraa.c.1706 Жыл бұрын
Great tutorial, very helpful! Thx a lot! 😘
@MyExcelLife Жыл бұрын
Thank you!!
@a.fleischbender7681 9 ай бұрын
Great turorial! Very educational
@MyExcelLife 9 ай бұрын
Thank you a lot!
@alializadeh8195 2 жыл бұрын
Thanx
@MyExcelLife 2 жыл бұрын
You're welcome
@sohelnirban5372 Жыл бұрын
Hello if I want to copy only specific range instead of full sheet then what would be VBA code ?? Could you please answer ??
@MyExcelLife Жыл бұрын
Hi, it depends where you would like to copy it - To the same sheet/workbook?
@sohelnirban5372 Жыл бұрын
@@MyExcelLife no I want to copy specific range and paste in to new workbook then this new workbook autosave in specific folder
@MyExcelLife Жыл бұрын
@@sohelnirban5372 You can do it by following - you will open a new workbook and use copy range to the first sheet and then to save it
@sunitaa1510 2 жыл бұрын
Easy explain madi full sharcut key
@MyExcelLife 2 жыл бұрын
You're welcome
@simondechoisy779 Жыл бұрын
Can I just say that using active workbook, activesheet and the sheet name as opposed to the sheet code name is something that no developer worth his salt would ever do. Also you could simply assign to the new sheet rather than copying.
@MyExcelLife Жыл бұрын
Hi, thank you for your comment. Really there are several options to copy the sheet using vba. I explained one of them which is used by me.
Chester Tugwell
Рет қаралды 150 М.
Ah Sing Excel TV
Рет қаралды 3,7 М.
MyOnlineTrainingHub
Рет қаралды 1,6 МЛН
Excel VBA Macro: Autofilter, Copy, Paste to New Sheet and Save to Specified Location (Dynamic Range)
greggowaffles
Рет қаралды 17 М.
Chester Tugwell
Рет қаралды 65 М.