Can I link an entire sheet into my master sheet?

beatea

It looks like I need more than Cell Linking in our master project tracker.

Do we have the ability to add a section on our master sheet so that any updates from a separate MARKETING TEAM sheet is displayed in the master sheet? I'm afraid simple cell linking only focuses on cells and won't take into account additional rows that get added.

Andrée Starå

Hi,

You'd use cross-sheet formulas and VLOOKUP or a combination of INDEX and MATCH.

Would that work?

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD