3. Time Saving Auto Custom Ribbon Buttons in Excel by VBA Automation (Add-In) #excelsdive #exceldive
Channel: Excel's Dive
Date: 2023-01-10

#vba #excel #tutorial 
In this video you will know that how to use this file in personal or official work for time saving just click button and many task will be complete in seconds.

File Link:- https://drive.google.com/file/d/16LB49QHItkyPi9g9nV3cFq2tKQWztUjs/view?usp=sharing

Playlist:  Creativity & Time Saving Files
Link:  https://www.youtube.com/playlist?list=PLUnXnMjm583F1JmAlI_T8aiuJ_o8lPBy7

CUSTOM BUTTONS AND DESCRIPTION:-
Separate Tools:-
Button- 1 - "Create Separate Sheets" of Selected Column Value on One Click
Button- 2 - "Create Separate Workbooks" of Selected Column Value on One Click

Combine Tools:-
Button- 3 - "Create Combine Sheet of All Sheets" on One Click
Button- 4 - "Create Combine Sheet of Selected Sheets" on One Click
Button- 5 - "Create Combine Sheet of Selected Workbook Sheets" on One Click
Button- 6 - "Create Combine Sheet of Selected Sheets of Selected Workbook" on One Click

Sort Tools:-
Button- 7 - "Sorting Sheets" Ascending Order on One Click
Button- 8 - "Sorting Sheets" Descending Order on One Click
Button- 9 - "Sorting Sheets" Number-Wise Order on One Click

Sheets Tools:-
Button- 10 - "Create Sheet Name List" on One Click
Button- 11 - "Rename Sheet Name List-Wise" on One Click
Button- 12 - "Word Add Right Side in Sheet Name" on One Click
Button- 13 - "Word Add Left Side in Sheet Name" on One Click
Button- 14 - "Word Remove Right & Left Side from Sheet Name" on One Click

File Path Tools:-
Button- 15 - "Files and Folders List" Create in Excel Sheet on One Click
Button- 16 - "Copy Files by Hyperlink in Another Folder" on One Click
Button- 17 - "Move Files by Hyperlink in Another Folder" on One Click
Button- 18 - "Delete Files by Hyperlink from Any Folder" on One Click

Rename Tools:-
Button- 19 - "Pick Files Name" from any folder on One Click
Button- 20 - "Rename Files Name" of any folder on One Click

External Tools:-
Button- 21 - "Unzip Many Files/Folders" on One Click
Button- 22 - "Export Table from Outlook" on One Click

#excelvba #vbaprogramming #exceltutorials #vbaforbeginners #excelautomation #vbafunctions #excelmacros #vbaforms #advancedvba #exceltipsandtricks