Excel TutorialExcel VBA TutorialTutorial

Excel VBA | Import Most Recently Created File into Current Workbook

This video demonstrates how to import the most recently created Excel workbook in a specified folder into the current workbook. The solution uses VBA's FileSystemObject. https://www.youtube.com/watch?v=ghy94Jrfjzo Here is the code featured in the video.

 

Read More
Excel TutorialTutorial

Create a Searchable Drop-down in Excel

Using data validation you can create useful drop-down lists in Excel.  If your list contains lots of values, it might be worth making it searchable.  The video below explains how this can be done - no VBA required!  Download the featured file here. https://www.youtube.com/watch?v=D6y8Rs0zUwo&t=65s Formulas used in the video Workings column =IF(ISNUMBER(SEARCH('Drop Down List'!$A$2,[@Product])),MAX($B$1:B1)+1,0) Drop…

Read More