Excel TutorialExcel VBA TutorialTutorial

Excel VBA to Combine All Workbooks in a Folder Into a Master Workbook

This video demonstrates how to write the VBA code that will combine all workbooks in a specified folder into a master workbook.  The video also includes the VBA code to sort the imported sheets by sheet name: in this example by month name.  The code is shown below the video.

 

70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf from our Excel training page
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf from our Excel training page
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!

https://www.youtube.com/watch?v=DpdKyEEmkgg

Read More
Excel TutorialExcel VBA TutorialTutorial

Hide Excel Sheet Based on Sheet Tab Colour – VBA Macro

This video details the VBA code needed to hide worksheets that have a coloured sheet tab. It also demonstrates how to hide sheets that have a sheet tab with a specific colour assigned. The VBA code is shown below the video. https://www.youtube.com/watch?v=7XfWTecO9AI VBA Code to Hide All Coloured Sheet Tabs

VBA Code to Hide…

Read More