Results 1 to 3 of 3

Text function for dynamic reference to select different sheets

Threaded View

  1. #1
    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

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. 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. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1