Filter Source Data in Excel with Slicer

I was recently answering a post on Ozgrid about filtering a list using a slicer. The post was very similar to a blog post of mine with a slight twist. The poster wanted the original list filtered based on the selection of the slicer and if no slicer item was selected then the filter was to be taken off the dataset. I found the problem interesting because in order to solve the problem you had to know how many slicer items were in the list in the first place.

Tags Excel, VBA, Slicer change, count, slicer, items, spreadsheet

Starting a Blog

I have been toying with the idea of a blog for some time now. Fact is my website is too large and the menus have too many items so on most screens the material drops off the page. I am limited as my choice of website builder does not offer scrolling drop down menus. It might be for the best as having 50 or more items under one menu is less than ideal.

Tags excel, spreadsheet, dna