sync rows between sheets
We have one large master action list for all clients. I'd like to be able to automatically pull data from that list so we can see at a glance what needs to be done for a specific client and save that on a tab in teams.Ideally I'd like the two to sync so changes made in either are replicated.
I don't think cell linking would achieve the sync objective. Could using conditions in some way work?