SOLVED
Home

hyperlink formula is not changing relative when copied to other calls

%3CLINGO-SUB%20id%3D%22lingo-sub-482384%22%20slang%3D%22en-US%22%3Ehyperlink%20formula%20is%20not%20changing%20relative%20when%20copied%20to%20other%20calls%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-482384%22%20slang%3D%22en-US%22%3EIn%20the%20attached%20file%20is%20a%20screen%20shot%20of%20a%20formula%20of%20a%20hyperlink%20function%20in%20are%20cell%2C%20when%20I%20try%20to%20copy%20it%20to%20other%20cells%20the%20cell%20reference%20of%20the%20(IF)%20partof%20the%20function%20changes%20relative%20but%20the%20two%20hyperlink%20cell%20references%20do%20not%20change%2C%20the%20formula%20is%20working%20but%20I%20need%20to%20manually%20change%20each%20line%20which%20is%20very%20long%2C%20does%20someone%20know%20how%20I%20can%20get%20this%20corrected%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-482384%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Erelative%20hyperlink%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-482427%22%20slang%3D%22en-US%22%3ERe%3A%20hyperlink%20formula%20is%20not%20changing%20relative%20when%20copied%20to%20other%20calls%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-482427%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F326785%22%20target%3D%22_blank%22%3E%40Al-1_2surf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi!%20The%20two%20last%20references%20are%20not%20working%20because%20they%20are%20inside%20double%20quotes.%20Please%20try%20to%20replace%3C%2FP%3E%3CP%3EFEEDBACK'!C9%22%3C%2FP%3E%3CP%3Ewith%3C%2FP%3E%3CP%3EFEEDBACK'!%22%20%26amp%3B%20C9%3C%2FP%3E%3CP%3Ein%20the%20last%20two%20references.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-485427%22%20slang%3D%22en-US%22%3ERe%3A%20hyperlink%20formula%20is%20not%20changing%20relative%20when%20copied%20to%20other%20calls%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-485427%22%20slang%3D%22en-US%22%3EThank%20you%20it%20worked%2C%20something%20so%20simple%20now%20that%20Isee%20it%2C%20won't%20make%20that%20Mistake%20again%2C%20how%20do%20I%20make%20this%20thread%20solved-%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-486071%22%20slang%3D%22en-US%22%3ERe%3A%20hyperlink%20formula%20is%20not%20changing%20relative%20when%20copied%20to%20other%20calls%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-486071%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F326785%22%20target%3D%22_blank%22%3E%40Al-1_2surf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20happens%20a%20lot%20that%20the%20solution%20is%20right%20there%20and%20we%20can't%20see%20it.%20%3A-)%26nbsp%3BGlad%20that%20I%20could%20help.%26nbsp%3B%20Good%20luck%20with%20Excel!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Al-1_2surf
New Contributor
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
3 Replies
Solution

@Al-1_2surf 

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-

@Al-1_2surf 

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!

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies