Click Here!
Results 1 to 2 of 2

Thread: Microsoft Excel question

  1. #1
    beingbobbyorr
    Guest

    Default Microsoft Excel question

    I have a workbook that has many worksheets (Sheet1, Sheet2, etc.,)

    Let's say on Sheet1 I want to reference values on the other sheets (Sheet2, Sheet3, etc.,), but I want to quickly change which sheets those are (i.e., sometimes I want to be referencing Sheets 3 to 5, another time I want to point to Sheets 9 to 11).

    So, whereas normally in the formula for a cell in Sheet1 I would write a absolute reference like this:

    =Sheet2!B2

    .... what I want now is to replace the hardcoded string "Sheet2" with some kind of reference to another cell on Sheet1 that will contain a formula that I can easily change to different Sheet #'s as needed.

    Any ideas?

  2. #2
    I'm Cultured, Bitch ianmonsta's Avatar




    Join Date
    Jan 2007
    Posts
    7,468
    Liked
    372 times
    Karma
    1000000
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quoted
    0 Post(s)

    Default

    hmm..

    So what if you just had a sheet that was all the formulas you want to update?

    so in =Sheet1!a1 you had =Sheet2!B2

    perhaps im not understanding you but i think that should work?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28