Forum Discussion
Solved
hyperlink formula is not changing relative when copied to other calls
In the attached file is a screen shot of a formula of a hyperlink function in are cell, when I try to copy it to other cells the cell reference of the (IF) partof the function changes relative but the...
Hi! The two last references are not working because they are inside double quotes. Please try to replace
FEEDBACK'!C9"
with
FEEDBACK'!" & C9
in the last two references.
Hi! The two last references are not working because they are inside double quotes. Please try to replace
FEEDBACK'!C9"
with
FEEDBACK'!" & C9
in the last two references.
Thank you it worked, something so simple now that Isee it, won't make that Mistake again, how do I make this thread solved-
It happens a lot that the solution is right there and we can't see it. :-) Glad that I could help. Good luck with Excel!