Reference an entire column and sync it with another column in a secodn sheet

Daniel Demers

Looking to take all 150 rows from a column in sheet 1 and sync them to sheet 2. Any changes to sheet 1 should be reflected in sheet 2.

Andrée Starå

Hi @Daniel Demers

You can either use cell-linking or a cross-sheet formula (VLOOKUP or INDEX/MATCH).

Would any of those options 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!