Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

excel question

Options
  • 22-03-2006 10:08pm
    #1
    Johnny_the_fox
    Registered Users Posts: 2,681 ✭✭✭


    Hi,

    using the address() function.. is it possible to use the ref for linking it to another worksheet?

    example

    after using the address() function

    Sheet2 - A1 = $C$5

    I would like to use this ref (A1) to do something like =Sheet1! XXXXX

    XXXX being the value in sheet2 A1


    ?


Comments

Advertisement