LinkBack URL
About LinkBacks
Is there a way that i can have list that will sort automatically. Currently the list is on a separate sheet in the same workbook.
I would like it to sort every time the data is updated.
Is there an easy way to do this?
George
Is there a way that i can have list that will sort automatically. Currently the list is on a separate sheet in the same workbook.
I would like it to sort every time the data is updated.
Is there an easy way to do this?
George
Your thread tiltle could use a little work
Do you want the actual data to sort, or a copy of the data? What does the data look like? Please be a bit more detailed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sorry about that, I was trying to do it from my phone.
I need th copy of the data to sort. The data has three columns (name, grade and Points). When the data is updated on the main page i would like it to automatically sort by the points column without having to sort it every time.
Sorry about that, I was trying to do it from my phone.
I need th copy of the data to sort. The data has three columns (name, grade and Points). When the data is updated on the main page i would like it to automatically sort by the points column without having to sort it every time.
Take a look at using large() - for sorting big-to-small, or small() - for small to large. Then use index/match to return the rest of the data.
If you will be having duplicate data, you may need to add a helper column to the original data and use a countif()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks