+ Reply to Thread
Results 1 to 5 of 5

I want to be able to create a dynamic reference in excel, for exam

  1. #1
    Lee
    Guest

    I want to be able to create a dynamic reference in excel, for exam

    My 1st tab is a summary report... references information for all the other
    tabs. I want to be able to automatically update the summary report on the
    first tab, by entering the day # of the year, and from this... the reports
    will automatically reference the next row (based on day) on the other tabs -
    so that I don't have to manually update each of the references in my report

    meaning...

    I start out with this formula in the First Tab: ='tab2'!C94
    but I want to make the row 94 dependant upon a cell in tab1, so I'm trying:
    ='tab2'!C(Y2)

    but this is giving me an error message. Does anyone have any suggestions
    how I could proceed?

  2. #2
    Biff
    Guest

    Re: I want to be able to create a dynamic reference in excel, for exam

    Hi!

    Try this:

    =INDIRECT("''tab2'!C"&Y2)

    Biff

    "Lee" <Lee@discussions.microsoft.com> wrote in message
    news:B7763CAC-E494-44B6-A53C-8A0D626F6767@microsoft.com...
    > My 1st tab is a summary report... references information for all the other
    > tabs. I want to be able to automatically update the summary report on the
    > first tab, by entering the day # of the year, and from this... the reports
    > will automatically reference the next row (based on day) on the other
    > tabs -
    > so that I don't have to manually update each of the references in my
    > report
    >
    > meaning...
    >
    > I start out with this formula in the First Tab: ='tab2'!C94
    > but I want to make the row 94 dependant upon a cell in tab1, so I'm
    > trying:
    > ='tab2'!C(Y2)
    >
    > but this is giving me an error message. Does anyone have any suggestions
    > how I could proceed?




  3. #3
    Lee
    Guest

    Re: I want to be able to create a dynamic reference in excel, for

    Thanks for the response... but I'm getting a #REF

    What can I show you to work through this?

    Thanks,
    Lee


    "Biff" wrote:

    > Hi!
    >
    > Try this:
    >
    > =INDIRECT("''tab2'!C"&Y2)
    >
    > Biff
    >
    > "Lee" <Lee@discussions.microsoft.com> wrote in message
    > news:B7763CAC-E494-44B6-A53C-8A0D626F6767@microsoft.com...
    > > My 1st tab is a summary report... references information for all the other
    > > tabs. I want to be able to automatically update the summary report on the
    > > first tab, by entering the day # of the year, and from this... the reports
    > > will automatically reference the next row (based on day) on the other
    > > tabs -
    > > so that I don't have to manually update each of the references in my
    > > report
    > >
    > > meaning...
    > >
    > > I start out with this formula in the First Tab: ='tab2'!C94
    > > but I want to make the row 94 dependant upon a cell in tab1, so I'm
    > > trying:
    > > ='tab2'!C(Y2)
    > >
    > > but this is giving me an error message. Does anyone have any suggestions
    > > how I could proceed?

    >
    >
    >


  4. #4
    Lee
    Guest

    Re: I want to be able to create a dynamic reference in excel, for

    I removed one of the ' before tab2 and it seems to now be working!
    Thanks for your help!

    "Biff" wrote:

    > Hi!
    >
    > Try this:
    >
    > =INDIRECT("''tab2'!C"&Y2)
    >
    > Biff
    >
    > "Lee" <Lee@discussions.microsoft.com> wrote in message
    > news:B7763CAC-E494-44B6-A53C-8A0D626F6767@microsoft.com...
    > > My 1st tab is a summary report... references information for all the other
    > > tabs. I want to be able to automatically update the summary report on the
    > > first tab, by entering the day # of the year, and from this... the reports
    > > will automatically reference the next row (based on day) on the other
    > > tabs -
    > > so that I don't have to manually update each of the references in my
    > > report
    > >
    > > meaning...
    > >
    > > I start out with this formula in the First Tab: ='tab2'!C94
    > > but I want to make the row 94 dependant upon a cell in tab1, so I'm
    > > trying:
    > > ='tab2'!C(Y2)
    > >
    > > but this is giving me an error message. Does anyone have any suggestions
    > > how I could proceed?

    >
    >
    >


  5. #5
    Biff
    Guest

    Re: I want to be able to create a dynamic reference in excel, for

    Ooops!

    I think I had one too many ' in there. Here's the "exploded" view for easy
    reading:

    =INDIRECT( " ' tab2 ' ! C " & Y2 )

    Just remove all the spaces.

    Biff

    "Lee" <Lee@discussions.microsoft.com> wrote in message
    news:EF064BD9-EAA7-4EDB-A51E-BF0AAFE905E7@microsoft.com...
    > Thanks for the response... but I'm getting a #REF
    >
    > What can I show you to work through this?
    >
    > Thanks,
    > Lee
    >
    >
    > "Biff" wrote:
    >
    >> Hi!
    >>
    >> Try this:
    >>
    >> =INDIRECT("''tab2'!C"&Y2)
    >>
    >> Biff
    >>
    >> "Lee" <Lee@discussions.microsoft.com> wrote in message
    >> news:B7763CAC-E494-44B6-A53C-8A0D626F6767@microsoft.com...
    >> > My 1st tab is a summary report... references information for all the
    >> > other
    >> > tabs. I want to be able to automatically update the summary report on
    >> > the
    >> > first tab, by entering the day # of the year, and from this... the
    >> > reports
    >> > will automatically reference the next row (based on day) on the other
    >> > tabs -
    >> > so that I don't have to manually update each of the references in my
    >> > report
    >> >
    >> > meaning...
    >> >
    >> > I start out with this formula in the First Tab: ='tab2'!C94
    >> > but I want to make the row 94 dependant upon a cell in tab1, so I'm
    >> > trying:
    >> > ='tab2'!C(Y2)
    >> >
    >> > but this is giving me an error message. Does anyone have any
    >> > suggestions
    >> > how I could proceed?

    >>
    >>
    >>




+ 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