VBA

Combine the Workbooks in a Folder

Concatenate the Data in a Range

Copy the Filtered Data after Filtering with the AutoFilter

Create Cascading ComboBoxes in a UserForm

Create Workbooks from the Data in a Worksheet

Delete the Filtered Data after Filtering with the AutoFilter

List the Files in a Folder and SubFolders

List the Files in a Folder with the DIR Function

List the Files in a Folder with the FileSystemObject

List the Unique and Concatenated Corresponding Values

Open the Latest File in a Folder

Sum Based on a Single Criteria Across All Sheets with a Custom Function

Last Update: November 9, 2011