#1
|
|||
|
|||
Sort Excel table using a list.
I have a long list that I want to use to sort my excel sheet.
I know that Excel has a solution for this onboard but my list and the table is 350 terms long and I cannot create a custom sort in this size. Excel does not allow this. If anyone knows how to do this with such a large list, I'd be happy to help. I'm looking for a VBA that I can use to sort the table. In the example table in the link is a list in column A of the spreadsheet T1. The table in T2 (also column A) should be re-sorted using this list. This table is an extract. The original is longer. I am happy about a code that can help me. Thank you very much. Example |
#2
|
|||
|
|||
Evernote - note not found
Is that really what the link should be ? Would be best to post a sample workbook to the forum. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can't sort list in report | Sharif | Project | 0 | 10-21-2019 03:02 AM |
Sort complex Excel Table with VBA | mthwi | Excel Programming | 0 | 11-27-2017 06:29 AM |
Sort items in a list into various customers for a report | Lluewhyn | Excel | 5 | 10-21-2016 05:56 AM |
list of documents come up in random order - any ideas how to sort this? | tallscot49 | Word | 0 | 07-18-2010 12:40 AM |
Sort By Last Name in a List | eliz.bell | Word | 8 | 05-07-2009 01:33 PM |