| The benefits of organized data saves time and money. It helps make intelligent decisions and allows you to move on to the next step. Getting that data into the order needed to make critical decisions quickly can be confusing for some. Having several fields of data only compounds the problem when you have to make repetitive steps for the same content. This particular data file has 16,755 rows, yet it can be sorted by any column in 1 second, and sorted by any column in reverse order in 1 second. Now consider needing to review that same data but in reverse. You’re repeating so many steps but the outcome is beneficial and necessary. What if you could have a tool to do it for you at the click of a button? You need to review each column and compare it to another column, and then another, then review it in reverse order. Each step involves the risk of mixing the data up into unrecognizable garbage if you fail to select all the data before sorting, or thereby getting invalid input.The image above may look very similar to you in that your data has many fields and unending rows. Having Excel macros that are controlled toggle buttons allow the click of a button to quickly see, review and compare a massive block of data instantly, without manually taking the steps to select, open a sort box, chose which column, and sort criteria, and review, and probably forgetting what you just reviewed and have to do it all over again.You say “What about using filters, that acts like a huge sorting option, won’t that work just as easy and we don’t need any special customizing?”. Yes, you can use filters, and select a few items in the filter drop downs, and get similar results, but, you’ve now limited your viewing of the whole picture by filtering out other factors which could have an impact on the decision making. You can still use the ‘Filter’ option after sorting with your Excel macro’s, so you can have a double bonus by using both. But depending on your final goal, the filter could work just fine to get the answers you need. I’ve just found filtering removes data that could be helpful to make quality decisions, so most of the time I like to just use the ‘Sorting’ option.Here are some thoughts on leaving the filter option turned off, and having all the data available and just sort the columns by its properties. (Smallest to Largest, A to Z):
You can ‘add to’ the page with updated data from the same source. The great benefit of this is there is no need to get the new input in order before you add it to the page. Once the page has the new data in place, just click on the button of your choice and its all instantly organized along with the existing data, just as if it had been there all along. Once a page has been developed it can be copied and used for other purposes by just populating it with new data as long as the content is of similar matter. Custom modifications are available upon request to fit any need.
The speed and ease of just clicking a button to sort any column in forward or reverse order will save you time and money. I welcome any challenge so that I can help you succeed quicker. Please contact me with your request today, let’s talk.
|
|
