Forum Discussion

kobus1305's avatar
kobus1305
Brass Contributor
Oct 20, 2020

Format Hyperlink that the cell number increases when copying

Hi,

I have a hyperlink in a workbook, on 160 cells in one column, that jumps to a second workbook and i need it to jump to the same row in the second workbook. HYPERLINK("[Quotation Unit Prices.xlsm]#January!G4","Open/Switch Unit Prices"). When copying the formula to other cells the G4 do not increases because it is inside the hyphen. How can i formulate the formula to achieve the G4 to increase to the rows?

Regards

Thank You

excel

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Oct 20, 2020

    kobus1305 

    With your permission, if I can recommend you, add a file (without sensitive data) to your project.

    Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.

    At the same time, it is much easier for someone who wants to help to understand the subject.

    A win-win situation for everyone.

    Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.

     

    * Knowing the Excel version and operating system would also be an advantage.

     

    Thank you for your understanding and patience

     

     

    Nikolino

     

    I know I don't know anything (Socrates)