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.
Read MoreRed, 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.
Read MoreImport 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.
Read MoreFeatured Posts
Recent Posts
Inflation Over Multiple Years in a Single Cell January 10, 2025
Hubspot Dashboard October 3, 2024
Monthly Dashboard With Supporting Metrics September 25, 2024
Excel Show Missing Sheet Tabs July 29, 2024
Run Macro Overnight Automatically June 24, 2024
Split File into Parts and Save to Directory April 20, 2024
Most Popular Author December 14, 2023
Creating an Excel Dashboard - A Guide with Templates December 8, 2023
Real Estate Excel Dashboard October 11, 2023
Updating Excel Dashboards September 29, 2023