Excel and Excel VBA Tips and Tricks
Excel and Excel VBA Tips and Tricks offers special tips on Conditional Formatting, Vlookup, Validation, Dynamic Ranges within a range and some slick uses for Checkboxes. It also includes a UDF to Count ,Sum and Sort by color, Generate x non-repeating random numbers between a top and bottom range, Find the specified occurrence matching criteria from two Columns.The step-by-step instructions tell you how to add descriptions to UDF's and how to create their category. It also enables you to create a dynamic "Sheet Navigator" that is added to the standard right click Pop-up menu.
|