Results 1 to 8 of 8

Alternative to INDIRECT for dynamic worksheet references

Threaded View

Joe26 Alternative to INDIRECT for... 05-22-2019, 10:57 PM
6StringJazzer Re: Alternative to INDIRECT... 05-22-2019, 11:32 PM
FDibbins Re: Alternative to INDIRECT... 05-23-2019, 12:05 AM
Joe26 Re: Alternative to INDIRECT... 05-23-2019, 12:14 AM
6StringJazzer Re: Alternative to INDIRECT... 05-23-2019, 09:05 AM
6StringJazzer Re: Alternative to INDIRECT... 05-23-2019, 10:53 AM
Joe26 Re: Alternative to INDIRECT... 05-23-2019, 09:16 PM
6StringJazzer Re: Alternative to INDIRECT... 05-23-2019, 09:42 PM
  1. 05-23-2019, 12:14 AM #4
    Joe26 is offline
    Registered User
    Join Date
    12-18-2014
    Location
    California
    MS-Off Ver
    Mac 2011
    Posts
    12

    Re: Alternative to INDIRECT for dynamic worksheet references

    6SrtingJazzer,

    Thanks for the reply. I'm not sure we're on the same page. My formula needs to pasted down column B, with multiple sheet names listed down column A (not just A1). Would your VBA code do that? I've attached an example workbook.

    Thanks!
    Attached Files Attached Files
    Last edited by Joe26; 05-23-2019 at 12:18 AM.
    Reply With QuoteRegister To Reply
« 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 References Based on Two Criteria (INDIRECT OR VLOOKUP?)
    By hotelguy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-08-2015, 09:52 PM
  2. [SOLVED] Using Indirect() to get dynamic references in an array formula
    By jlb333333 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-18-2015, 10:37 AM
  3. [SOLVED] SUMPRODUCT(SUMIF(INDIRECT with Dynamic Worksheet Range
    By decipher in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-07-2014, 05:40 AM
  4. [VBA] Indirect copy to dynamic worksheet
    By Armitage2k in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2014, 12:15 AM
  5. Excel 2007 : need formula for Dynamic Sheet references without indirect
    By Fuuma in forum Excel General
    Replies: 1
    Last Post: 02-18-2012, 10:31 AM
  6. Dynamic worksheet references
    By David Boothe in forum Excel General
    Replies: 3
    Last Post: 05-28-2006, 07:15 AM
  7. Dynamic formulas including worksheet references
    By lars22222 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-06-2005, 06:05 PM

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