We are collected some useful and most wanted excel macros which can help you in everyday without problems. Excel Dashboard School’s vba macro collection contains very simple macros.
Just see the code editor to understand Excel VBA logic and the core spreadsheet functions. We hate the manual data manipulations in excel so much.
Table of Contents
Most wanted VBA macro collection
Delete blank rows in a selected range
Deleting non-empty rows in a range is certainly a common problem that we see in daily excel usage. Using this simple vba macro you can scan the selected range and quickly delete the empty rows from a short list or a long range.
First select the range then press ALT + F8 to open the Macro window finally run the selected macro. Here is a sample workbook to try this great function.
Find the last non-empty cell in a row
Now here is one of a frequently asked questions. How to return the last non blank cell in a row or column?
If trouble comes around use our little vba code, we hope it can be helpful.
Here’s what we are looking for. Click here to download the sample spreadsheet to analyse the solution.
Eliminate duplicate values in a column
The third part of vba macro collection is a duplication challenge. Here is nothing special, select the range which contains the values and run the macro.
Very important: this way working correctly only by a sorted list.
View the attached template to learn the trick!
Highlight Selected Cell in a Data table
If you create dashboard in Excel or develop business reports it’s your Swiss knife! You can visualize the key things that are important.
If you like it, you can download it, no worries…
Consolidate data from separated files
How to consolidate data from multiple excel files using vba? Check this macro it is a powerful lightweight solution for managing separated data tables.
Click the link to manage your personal database.
How to clean data in Excel – Ultimate Guide