Collect live data from a sheet to a sheet by not using report

Archie Villa

Hi Everyone

May i know if there is a way to live collect data from a sheet to another without using the Report function due to confidentiality issues?

My mastersheet have list of names, i want to collect all the data to a specific name on the master sheet. Is there a way to do that?

thank you

Andrée Starå

Hi Archie,

Yes, there is.

We can use cross-sheet formulas and either VLOOKUP or a combination of INDEX/MATCH for that.

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post 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!