•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Sync between multiple sheets and sorted by different column
I currently have an excel file with two sheets. The data in each sheet is the same but sorted by different columns. Currently I am double entering the data in each sheet. Is it possible to sync data from one sheet to another but have the data sorted by a different column? I know I can keep resorting when I need to see it sorted a certain way but the constant sorting is taking too much time when I flash back and forth so much.
For example, sheet 1 has all the data entered and sheet 2 is a copy of that data just sorted differently. Then when new data is entered into sheet 1 it auto syncs to sheet 2 and is auto sorted.
[link] [comments]
Want to read more?
Check out the full article on the original site