relative hyperlink
1 Topic
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 correctedSolved2.1KViews0likes3Comments