+ Reply to Thread
Results 1 to 3 of 3

Text function for dynamic reference to select different sheets

  1. 10-01-2019, 02:54 AM #1
    Zaorski
    Zaorski is offline
    Registered User
    Join Date
    09-04-2019
    Location
    Zabrze, Poland
    MS-Off Ver
    2016
    Posts
    6

    Text function for dynamic reference to select different sheets

    Hello everyone

    I'd like to ask if it is possible to make dynamic reference in formulas like in attachment.
    My point is - I got many formulas with external reference to another workbook. Workbook from which data is taken has sheets named 01.2019; 02.2019; 03.2019; 04.2019 etc.
    So in formulas I have to select sheet for right month. Is it possible to make it dynamic - based on what is written in cell G4? So when G4 says "06.2019" all formulas ref to June and when G4 says "07.2019" formulas ref to July.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-01-2019, 03:02 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Text function for dynamic reference to select different sheets

    =SUM(INDIRECT("'"&$G$4&"'!A2:A11"))

    and siumilar for the other functions.
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  3. 10-01-2019, 04:43 AM #3
    Zaorski
    Zaorski is offline
    Registered User
    Join Date
    09-04-2019
    Location
    Zabrze, Poland
    MS-Off Ver
    2016
    Posts
    6

    Re: Text function for dynamic reference to select different sheets

    Works. Thank you sir!
    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. dynamic cell reference from other sheets
    By saaadi1616 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-12-2017, 06:13 AM
  2. Need multiple workbooks to reference a dynamic list based on those sheets
    By jayclinton in forum Excel General
    Replies: 1
    Last Post: 01-31-2017, 06:32 PM
  3. [SOLVED] Select all sheets from a dynamic list
    By rousseauassociates in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-23-2016, 05:14 AM
  4. Indirect Sheet reference with cell reference left function and text
    By teststrip in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-01-2015, 10:31 AM
  5. [SOLVED] Dynamic reference text within formula
    By jorjacman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-19-2013, 10:36 AM
  6. [SOLVED] Dynamic Function Reference Question
    By excel newbie in forum Excel General
    Replies: 1
    Last Post: 04-20-2005, 04:06 PM
  7. [SOLVED] sheets.select with reference to Cells value
    By mooky104@hotmail.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2005, 02:06 PM

Tags for this Thread

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