+ Reply to Thread
Results 1 to 4 of 4

Calling string inside cell reference to reference another sheet.

  1. 12-26-2013, 02:43 PM #1
    {=OR(value=array)}
    {=OR(value=array)} is offline
    Registered User
    Join Date
    10-14-2013
    Location
    Saturn
    MS-Off Ver
    Excel 2010
    Posts
    28

    Calling string inside cell reference to reference another sheet.

    Hi,

    Suppose in Sheet1, A1='Sheet2

    I would like to reference a cell on Sheet2, say 'Sheet2'!A1, but instead of typing in "Sheet2", I would a reference to A1 in Sheet1 (whose value is 'Sheet2).

    Can this be done?

    Thanks!
    Reply With QuoteRegister To Reply
  2. 12-26-2013, 03:10 PM #2
    vamosj
    vamosj is offline
    Forum Contributor vamosj's Avatar
    Join Date
    04-23-2004
    Location
    Oregon
    MS-Off Ver
    2010
    Posts
    294

    Re: Calling string inside cell reference to reference another sheet.

    I am having a hard time deciphering exactly what you want? Are you looking to have Cell A1 in Sheet 1 to show the same exact value as Cell A1 on sheet 2? Or are you trying to make it so when you type a sheet number in Sheet 1 Cell A1 it shows the referenced sheet's Cell A1 value?
    Janos S. Vamos
    Data Systems Technician/Fire Controlman PO1(SW/AW)
    US Navy Retired

    Remember, Record Macro can be your friend for figuring out solutions.

    Good or Bad, let me know how I did by clicking on the "Add Reputation" * just to the lower left of here. it only takes a few seconds to let someone know.
    Reply With QuoteRegister To Reply
  3. 12-26-2013, 03:13 PM #3
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Calling string inside cell reference to reference another sheet.

    Perhaps.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  4. 12-26-2013, 04:45 PM #4
    {=OR(value=array)}
    {=OR(value=array)} is offline
    Registered User
    Join Date
    10-14-2013
    Location
    Saturn
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Calling string inside cell reference to reference another sheet.

    Quote Originally Posted by Norie View Post
    Perhaps.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Oh there we go. Thanks. My brain decided to forget INDIRECT today.http://www.excelforum.com/newreply.p...3928&noquote=1
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Dragging formula, change sheet reference, but not cell reference
    By Kalilaya0419 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-13-2013, 04:50 PM
  2. [SOLVED] Reference to cell in another sheet with a string
    By chrotto in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-06-2012, 03:13 AM
  3. Cell Reference Inside DDE Link
    By Excel-sior in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2009, 02:01 PM
  4. DDE syntax (cell reference inside)
    By fbrito in forum Excel General
    Replies: 0
    Last Post: 09-28-2007, 04:47 PM
  5. pulling from 'line' inside cell- best way to reference in VBA?
    By KR in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2006, 11:15 AM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1