+ Reply to Thread
Results 1 to 2 of 2

Using a variable inside a worksheet reference in a formula

  1. #1
    Registered User
    Join Date
    07-20-2011
    Location
    PA
    MS-Off Ver
    Excel 2003
    Posts
    16

    Using a variable inside a worksheet reference in a formula

    I am new to the forum so hopefully this is the right place to post this.

    =(INT(J4)+(J4-INT(J4))/60*100)-(INT(VVINSTAC173RT!J4)+(VVINSTAC173RT!J4-INT(VVINSTAC173RT!J4))/60*100)+VVINSTAC173RT!N$4

    Here is my problem;

    I am trying to work with a master worksheet. I want to be able to have all of my formulas on it and when I need to be able to copy and move in into another excel file. Is there a way to reference a excel worksheet name and have a section of it as a variable depending on what file I copy the mast sheet into?

    I want 173RT to be a variable that is replaced by whatever value is in C4 depending on what file I copy my master sheet into.

    If I am not using the write wording I will be more specific with what I am actually working with.

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Using a variable inside a worksheet reference in a formula

    Hello Guinness,

    Use INDIRECT formula,

    Please Login or Register  to view this content.
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1