We have a workbook that has grown too large and has gotten to the point where we keep getting the "too many cell formats" message. I need a macro that will wipe out all of the formating so we can go and re-key it and uniform as much as possible where we can.
Styles are one of the most underutilized features in Excel. If you format your workbook using styles rather than individually tweaking each format attribute on an instance by instance basis,
A little background as to how I came to I design this code:
Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.