Linking Two Sheets to update dynamically When columns are added and removed.

Matt Penta · 10/28/19

I have two sheets that i want to be linked dynamically. EX:

Column 1:

1

2

3

4

5

I want to be able to have this column automatically update and be created on the second sheet when it is changed on the first. If for example, I were to add in a row between two and three with a value of 2.5, I would like this to update on Sheet 2. Currently i just have them linked in a manner that will only update that information if there was already a row in place or an empty row. It, however, will not update new rows that are added or rows that are removed for various reasons. Any idea how to set up a formula that will automatically pull all data points in this column and Create/remove rows as needed in sheet2?

Andrée Starå · 10/28/19

Hi Matt,

It sounds like we could use cross-sheet formulas or cell-linking to make this work.

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Matt Penta · 10/28/19

I shared the Links and sent you an email with more details. What I am looking for is a more accurate cell linking that will update when rows are added/removed if that is possible.

Andrée Starå · 10/28/19

Thanks!

I'll take a look and get back to you!

Best,

Andrée

Sherry Xu · 02/12/20

Any updates on this?

Andrée Starå · 10/10/20

Hi @Sherry Xu & @Matt Penta

I'd be happy to share an example.

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

Be safe and have a fantastic weekend!

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!

YValentine · 02/12/21

Could you send me examples of how to make something like this work?

Andrée Starå · 02/12/21

@YValentine

I'd be happy to share an example.

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

Melissa_ · 06/20/21

Hello Andree - Were you able to find an answer to the original question? I'm also looking to have a column on one sheet update if a column on another sheet is updated with new data and/or new rows. Thank you.

rD7 · 03/22/23

Hi Melissa, I have the same requirement as you do, were you able to find a workaround?

Linking Two Sheets to update dynamically When columns are added and removed.

Comments

Help Article Resources

Categories