Forum Discussion
Sort to another table
Windows 8.1 Excel 2016 I have a table (table1) with 3 columns. Cells in column 1 contain a single letter (A,B,or C) Column 2 contains a whole number (0-999) Column 3 contains a name (ex: Ann) I...
djpaul Perhaps I'm simplifying your problem, but why not Custom Sort Table1. First by ABC (A-Z), Then by Number (Largest to Smallest). Put filter buttons on the table. Filter out all A's, copy and paste to a new table. Repeat for B's and C's. This would be fairly straight-forward, though I admit it's not
dynamic or automated.
The data in table 1 changes on a regular basis. I'd like to automate the process.
When the data in table 1 changes, tables 2,3 and 4 would automatically update with no intervention.
djpaul OK. Then I would get into PowerQuery. Once set-up properly, you just need to do a refresh if Table1 changes, and that could even be automated.
See attached.
If you are not familiar with PowerQuery, this could be a good starting point:
- Thanks for the information. I was hoping someone out there had a relatively easy way of doing this using something like a VLOOKUP or SORTIF command.
