1
I am automating an excel based report and need a formula that will take cell A2
with its hyperlink
from Sheet2 and copy it to another column in Sheet 1. Hyperlink points to external web address. When I use just =A2
it copies the text but without the hyperlink.
How to do this? Thank you for your help
Hello, I cannot make it work. My link is very complex - it points to an object in SAP related tool located in company intranet and includes redirect. I receive NA when trying to change values for link start and end in the formula – Velin – 2018-05-10T08:34:11.103
what does the link start and end with ? – PeterH – 2018-05-10T08:35:48.440
link end: OBJECT_ID&crm-object-value=9000272438 – Velin – 2018-05-10T08:40:40.567
for every cell in the source column the number in the end is different and I want to be able to expand the formula with dragging down in destination column – Velin – 2018-05-10T08:42:54.493
link start update: globe7. – Velin – 2018-05-10T08:46:53.930