Copy and paste link to another sheet?
I use linked reporting extensively so that I don't have to repeat data capture. I often need to copy and paste the same link down a column in a sheet. However, when I copy and paste only the value transfers, not the link out to the data in the external sheet. Is there a way to do this?
Help Article Resources
Check out the Formula Handbook template!