Is there a way to link a range of cells?

I want to take the information highlighted in this spreadsheet:

and link to it in this spreadsheet:

so that if I change a value in the first spreadsheet, it will also change that value in the second one.

I know I can link cells, but it would take a very long time to individually link every cell (hundreds of them). There must be a better way to do this.

Best Answer

  • Gabriella Silvagnoli
    Answer ✓

    Hi Nita,

    Yes, you can highlight in bulk all the cells you need to be linked and then link it to the corresponding sheet. As long as it's in the same order you need it to be, it should be a quick process where you only have to spend time inking these 3 rows, not one by one.

    Hope this helps! :)