Hi all,
I have created an Excel sheet to help me manage and sort data often. I have no problem doing the work manually but i have been wondering whether or not it is possible to use a macro or VBA to make the process quicker (Apologies, I am new to excel so i have no idea how to start with this!)
On my spreadsheet, i have 5 tabs.
Range1-Range3 is where i would paste data from an external source (The only reason i use multiple tabs for this, is because other people would use this and it reduce the risk or errors this way given that the data could take up 1000s of rows).
When the three Range tabs are filled, i would copy and paste all, into the Data tab, adding headers then using formulas on columns C & D to get the results i am after.
Finally, i would copy everything on the Data tab and past into the Results tab so i can remove the duplicates from column A, ID, and sort the data according to the highest value on column D, keeping the top 10 on the list.
Any help or ideas to make this easier would be appreciated!
Thank you!
Bookmarks