Bulk cell-linking

Paul Newcome

Autofill should be pulling the formulas down into the new rows. You need to have at least 2 rows directly above the new entry that is of the same format and hierarchy and contains the formula.

sahilhq

@Paul Newcome Hi Paul! I hope you are doing well. I have a follow up question to ask related to the discussions we have had on this post.

So through the INDEX/MATCH formulas I have managed to link 4 sheets to a master sheet. So what's happening now is that anytime changes are made in the master sheet, the indivdual entity sheets automatically gets populated which is great. Is it possible to take it one step further by linking the master sheet to the 4 entity sheets as well such that anytime a change is made in any of the individual entity sheets, the master sheet also automatically gets populated? I am basically trying to achieve a 2-way link....

Andrée Starå

@sahilhq

It's possible, but it would have to be in another column.

Would that work?

sahilhq

@Andrée Starå Hey! Yes, that would work for me :)

Paul Newcome

The only way to achieve a two way link would be to use manual entry and a report. Everything else is going to be one way links.

Paul Newcome

@Andrée Starå Duh moment... I didn't even think of a second column for the other direction. I was just thinking 2 way link within the same cell. Glad you spoke up on this one.

sahilhq

@Andrée Starå Hey. Can you please provide the solution for adding another column. What formulas will I need to input and how do I relate the main sheet to the 4 sheets?

sahilhq

@Paul Newcome Any chance you can still assist with a solution please for adding the second column?