+ Reply to Thread
Results 1 to 3 of 3

Indirect Function and Worksheets

  1. 11-16-2018, 03:35 PM #1
    toaks32
    toaks32 is offline
    Registered User
    Join Date
    11-16-2018
    Location
    los angeles
    MS-Off Ver
    2013
    Posts
    2

    Indirect Function and Worksheets

    Please help!. I have an excel function that includes the indirect function and multiple worksheets. The worksheets are renamed as: data - fy1, data - fy2, data - fy3 and the formula references "data - ". However, the formula is pulling data from the data - fy3 worksheet. Please help me understand why and how the formula "data - " is used. Thanks.
    Reply With QuoteRegister To Reply
  2. 11-16-2018, 04:54 PM #2
    ratcat
    ratcat is offline
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111

    Re: Indirect Function and Worksheets

    G'day,

    Since there is no workbook to find out what your doing wrong click on the link for some info Click Here
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it
    Reply With QuoteRegister To Reply
  3. 11-17-2018, 03:17 AM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Indirect Function and Worksheets

    Hi, welcome to the forum

    At the very least, show us what formula you are using?
    (providing a sample file would be even better)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    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. How to move certain range between worksheets with Indirect function?
    By CountDom in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-30-2018, 10:17 AM
  2. Reference Same Cell From Multiple Worksheets In Excel Without using Indirect Function
    By cuchi33 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-09-2018, 10:18 AM
  3. INDIRECT function for other worksheets
    By AdiK in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-18-2017, 10:59 AM
  4. [SOLVED] INDIRECT Function with multiple sheets - SUMIF, INDIRECT & MATCH
    By DJDRU in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-07-2014, 08:42 AM
  5. Indirect function not refreshing between worksheets
    By lbobrien in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-18-2013, 07:21 PM
  6. [SOLVED] INDIRECT Function with various worksheets
    By bigmantitus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-21-2012, 04:37 AM
  7. indirect function in different worksheets, losing my hair!
    By Alexander Banz in forum Excel General
    Replies: 3
    Last Post: 02-16-2005, 11:59 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