We live in an age where many solutions to Excel and VBA programming problems can be found on the internet. However, one of the main purposes of this workbook is to provide solutions that would in many cases be difficult to find on the internet and, therefore, save a great deal of time in searching the internet. We have recently made SIX additions to our User Tips offerings, which are on sheets that have been coloured red to distinguish them from our previous offerings.
The following is a summary of all our offerings, with our new user tips shown in a red font colour on the sheet tabs:
Combo Box; ‘If’ conditions;
Concatenation formulas; Consolidation of several ranges with a pivottable;
Designating colours; Dynamic Ranges; Finding & Sorting;
Hiding cells; Identifying column differences; Matching references;
Posting to multiple sheets; Printing letters; Private Sub Macros;
Removing Blanks; Rounding a group of cells; Totalling and Chart Creation
