Background The Excel Advanced Filter gives you database like functionality and helps you crunch large datasets with ease it can also help you begin to better understand database structure. This article contains several tutorial videos related to the Advanced Filter, enjoy... Unlike the Autofilter which only allows you to filter on one element per column, the … [Read more...] about Understanding The Excel Advanced Filter
Excel vba
How To Create A VBA Form In Excel
We’re going to create a simple Excel vba form, that covers most of the concepts that you'll need to get up and running fast with your form creation in Excel VBA. The YouTube video tutorial below will take you through these concepts in more detail so lets get started. The result of this process will be a simple form with a text box for country and a text box … [Read more...] about How To Create A VBA Form In Excel
How To Make An Excel VBA Listbox Act Like A Grid
The Problem You're writing an Excel VBA Front end to some sort of system, it could be an Access, Sql Server or Oracle database, or some text files you're consolidating from third party data sources. You want to incorporate a Grid into your vba form so that it behaves similar to a Microsoft Access form and sub form relationship or any other slick third … [Read more...] about How To Make An Excel VBA Listbox Act Like A Grid
How To Resize A Named Range In Excel VBA
To resize a named range in Excel VBA it's best to get an object reference to the range and then use the Excel VBA resize method to resize the range. With the resized range object you then set it's name property to the range name that you want resized. Excel will behind the scenes delete the old range name and replace it with the one you have just created. The spreadsheet … [Read more...] about How To Resize A Named Range In Excel VBA
Question Time – Excel VBA – Consolidate Data From Different Sheets
In this tutorial we are going to merge excel files into one results file for uploading to an accounting system. Get the spreadsheet used in the tutorial above. Also get updates when new blog or video tutorials are released. Submitting... A reader's workflow … [Read more...] about Question Time – Excel VBA – Consolidate Data From Different Sheets