•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
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#real-time data collaboration
#big data management in spreadsheets
#conversational data analysis
#intelligent data visualization
#Excel compatibility
#google sheets
#rows.com
#natural language processing for spreadsheets
#financial modeling with spreadsheets
#sync
#data
#excel
#sheets
#sorted
#columns
#double entering
#auto sync
#copy