Excel is a handy tool for data manipulations and comparison of multiple data sources. When combined with VBA, Excel becomes an even more powerful tool for automating cumbersome jobs which otherwise may take up a long time for the user. One such example is comparing the values of cells across multiple columns. Using macro one can customize the code to look for specific values in ascending or descending order across the columns. Once the criteria specified by the user matches the relevant cells, the can either be highlighted or deleted as per the need of the user in this office software.