How to synch two sheets

Lydia Villalón

Hi...hope I can make myself clear on explaining my needs:

I have one main sheet created, this one's data is feeded with a form, so rows are automatically created each time the form is submitted. I need to filter from this mainsheet, certain rows and make them available in a second sheet that should be feeded by the rows that are automatically created on the first sheet. I need:

1- rows on the second file to be automatically created and updated based on the first file, as soon as a new row is created on the first - then on the second should get populated as well

2 - filtered criteria NOT able to be changed, meaning that I need that filtered view to be static always.

3 - columns' names are different from one sheet to another but the data is the same, for example in sheet one column name is A) Owner name - within second sheet, column name is Tracking actions lead, but the data in both field would be - John Banks, for example.

Andrée Starå

Hi @Lydia Villalón

I hope you're well and safe!

You could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Lydia Villalón

@Andrée Starå thanks!!!! I'll try that, I was trying to use the data mesh but seems is not intended in this type of cases. I'll let you know the outcome.

Regards!

Andrée Starå

@Lydia Villalón

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!