Showing related tags and posts accross the entire site.
-
With FastFilter, you can type criteria in the row above an AutoFilter, instead of selecting from the dropdown lists. The cells with criteria change colour, so you can easily see which columns have a filter applied, and see what the criteria are. You can filter one or more of the columns. This ZIP file...
-
This workbook has a sheet of each type available in Excel. if you click on the 'Create Index' button, it adds a worksheet with the worksheet name, type and, if possible, a hyperlink to that sheet. It just a file by way of VBA demo. (Alt+F11 to look at code)
-
This Macro will create a series of 12 files in the same Directory as this file is stored It is recommended that you create a new empty folder, save a copy of this file in that folder, and then run the macro. Each new file will be named Jan.xls through to Dec.xls Within each file, there will be an individual...