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 two hyperlink cell references do not change, the formula is working but I need to manually change each line which is very long, does someone know how I can get this corrected
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.
3 Replies
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!
