by John MacDougall | Nov 21, 2016 | Tips
In this post we’re going to learn how to create a conditional drop down list in a cell. This means the drop down list will depend on some other value in the workbook and the available values in the drop down menu will change depending on this value. For example, we...
by John MacDougall | Nov 21, 2016 | Tips
Get The Completed Workbook 1 Formatting a 7 digit number Let’s say we have a list of phone numbers and we want to have them formatted in the nice usual readable way. For example instead of seeing 2225678 we want to see 222-5678. We can use...
by John MacDougall | Nov 20, 2016 | Tips
Get The Completed Workbook Looking up a value based on one criteria Let’s say we have a table with employees and their total sales and we want a formula to return the total sales based on the employee. Now, if we want to get Allison’s...
by John MacDougall | Nov 16, 2016 | Tips
This post is going to explore how to get a list of file names in a folder without using any VBA code. This method uses the legacy Excel 4 XLM functions. These functions aren’t like Excel’s other functions such as SUM, VLOOKUP, INDEX etc. These functions...
by John MacDougall | Nov 8, 2016 | VBA
In this post we’re going to explore how to loop through various objects in Excel using VBA. Using these snippets of code you’ll be able to loop through sheets, open workbooks, files in a folder and named ranges in a workbook. Loop through all sheets in an...