Can I link an entire sheet into my master sheet?

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.

Find more posts tagged with

Formulas

Reports

Integrations

Project Management

Importing and Exporting

Cell linking

Account and User Management

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.
Nested IF Statements
Hello. I cannot figure this out. =IF([GL Code]@row = 14030, "Leasehold") How do I add additional IF statements in the same cell, for example if the GL Code@row = 14040, "FF&E", GL Code@row = 14050, "CR Equip" Thanks.
Original sheet is corrupted or has some hidden issue preventing the formula from working?
I have a sheet where a formula in one column is not being applied . However, when I save the sheet as new, the formula works as expected. Is it possible that the original sheet is corrupted or has some hidden issue preventing the formula from working?