I’m researching to see whether or not it’s possible to have two Excel tabs sync automatically and have the data ordered differently on both tabs.
Tab 1 is a mass casualty call list where all of our employees are ordered from the shortest ETA to our place of work to the longest. The second tab is just for a general staff call list that’d have the same data from Tab 1 just ordered alphabetically instead and minus the ETA column.
It’s a document that changes and needs updating frequently with staff turnover and new hires, so I’m just trying to see if there’s a way we can make things a little easier and not have to constantly update two separate tables.
