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
-
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! :)
Answers
-
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! :)
-
Thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives