example.xlsx
For a class I'm taking right now we are going to get weekly data for our teams (See top table on attached file). The data is arranged by team name. I want to have a macro rearrange it by highest percent in each city. In the file I have the data that's given and then below I rearranged a few so as to give you an idea of what I'm trying. This is my code so far:
I filled arrays of each category (team name, selling price, and market share %). I was hoping to be able to basically sort the array by the third row (market share %) and then loop through and paste them into the empty table below. But there are no standard functions for this, and I am struggling with coming up with a way around this. Any ideas? Anything would be appreciated. Thanks.Please Login or Register to view this content.
Bookmarks