Linking entire columns to another sheet

Alessandro Terranova

Hi Community,

I have a master Intake sheet fed by an intake form, this serves the purposes of multiple departments.

I would like to create a second sheet that automatically receives data from the primary intake sheet that only captures the requirements of a single department, this would imply to mirror only selected columns from the primary into the secondary sheet. Therefore, anytime an intake form is submitted this will create a new row in the primary intake sheet and automatically duplicate info for selected columns in the secondary sheet.

I would also be happy to mirror entirely the primary sheet into a second sheet and hide the non relevant columns in the secondary sheet if this may facilitate the solution. What matters is the zero maintenance needed to fill the secondary sheet.

Could anyone kindly help?

Thank you!

Andrée Starå

Hi Alessandro,

I’d recommend using cross-sheet formulas and VLOOKUP or a combination of INDEX/MATCH.

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(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!

Alessandro Terranova

Hi Andree,

Many thanks for your kind response. Could you please break further the procedure you have in mind?

Cell linking wouldn't work for entire columns, am I correct?

Thank you

Andrée Starå

@Alessandro Terranova

Happy to help!

I'd be happy to share an example. 

Please send me an email at andree@workbold.com, and I'll share it with you.