Fast Tip Friday – Open Link in New Tab Without Right-Click

This fast tip demonstrates how to create a dropdown list in an Excel workbook that pulls in values from a list in another workbook. In another Fast Tip Friday, I demonstrated how to create a dropdown list from another worksheet. Download Sample Files

Have you ever needed to add the same subfolder to a bunch of existing folders? For instance, let’s say you have a list of folders that are named by custodian and you need to add an Exhibits subfolder to each and every custodian folder. This fast tip demonstrates how to automate the task using an…