How can I create a link in multiple cells simultaneously?
I want to link a cell in one sheet to multiple cells in another sheet. The source cell contains a date, and I need that date to be linked to multiple cells (all in the same column) in another sheet.
I've tried highlighting multiple cells in the destination sheet and using Paste Special -> Links to copied cells, but that only creates a link in the very first cell. I've also tried highlighting multiple cells in the destination sheet -> right click -> Link from cell in other sheet...but that produces the same result. It only populates the first cell.
How can I go about creating links in multiple cells simultaneously? As it stands, I have 190+ rows that require this same link, and I would prefer not to perform this action 190 times.
Help Article Resources
Check out the Formula Handbook template!