Commonly in your input form you might have validation on a drop-down field ensuring the user picks their selection from a pre-defined list.   In this example we have named the range ‘ListRegions’ and set it across the cell range B4:B7 to ensure it includes all 4 regions.     We’ve set the field up with Data Validation Read More …

When you fill in an online form it is quite common that a choice of drop down options will be dependant on one of your previous answers. In this post we’ll look at how you can replicate that in Excel.   In this example, a firm has 8 offices across 3 different countries. When you Read More …

In this article we’re going to cover how to create a user input form step-by-step, with data inputted and automatically saved within the file along with a reporting dashboard. In this short space we can only really cover how to build a basic form, but all the important Visual Basic code, etc is included and hopefully Read More …