Advanced Filter a List Automatically

I was recently working on an automated procedure to generate data in a list based on drop down (data validation) selection. The idea is to change items in a drop down (data validation) and have the corresponding data table filter to the specific items chosen in your drop downs. I have shown a formula based solution for this method (a long time ago) so if a more simplistic solution hits the mark - the link can be found here.

Tags VBA, Spreadsheet, Advanced Filter, Excel, Automate

Red, Green, Blue Interior Cell Colour

Recently I was giving a half day course on heat maps and came up with the novel idea of creating a custom function which would identify the primary colour scheme for a cells interior colour. It is in an effort to save a little time in the creation of a colour scheme for heat mapping. Rather than laying down the colour and looking up the Red, Green and Blue numerical combination I simply lay the colour down and the custom function does the work for me.

Tags VBA, Custom Function, Red green blue, Excel, Spreadsheet, colour scheme, color

Import Website Data to Excel

I was recently asked to repair a webquery which had gone bad. The company controlling the website had changed the layout of the content. I decided to extract the data from the website into excel using VBA and a call on the HTML tables inside of the website itself. Obviously this technique works best where there are dedicated tables on a website. It does not discriminate as all data from the page is imported but with some smart manipulation you can inject some VBA to extract the relevant tables into a fresh worksheet.

Tags Import, Web, Data, Excel, Spreadsheet, vba