+ Reply to Thread
Results 1 to 3 of 3

Please Please Please! index or offset style referencing over multiple tabs

  1. 02-02-2023, 02:00 AM #1
    daxcallagher
    daxcallagher is offline
    Registered User
    Join Date
    11-12-2012
    Location
    Australia
    MS-Off Ver
    Office 365 Version 2301 PC
    Posts
    28

    Please Please Please! index or offset style referencing over multiple tabs

    Hey Guys
    I have a question about index or offset style referencing over multiple tabs.
    i have explained my question is this short video https://youtu.be/BB6_2Moj8lU

    any help greatly appreciated.

    Dax
    Attached Files Attached Files
    Last edited by daxcallagher; 02-02-2023 at 10:22 PM. Reason: No Reply's
    Reply With QuoteRegister To Reply
  2. 02-06-2023, 11:35 PM #2
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,607

    Re: Please Please Please! index or offset style referencing over multiple tabs

    A7:
    Please Login or Register  to view this content.
    change tab: BHD to Bulkheads
    Cell refs must be changed for each block (e.g. A6 -> A15,...
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  3. 02-06-2023, 11:51 PM #3
    daxcallagher
    daxcallagher is offline
    Registered User
    Join Date
    11-12-2012
    Location
    Australia
    MS-Off Ver
    Office 365 Version 2301 PC
    Posts
    28

    Re: Please Please Please! index or offset style referencing over multiple tabs

    Thanks Ben, Legend.
    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. Index and Match - multiple items multiple tabs/sheets
    By cmpx23 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-24-2021, 04:06 AM
  2. Sumif and Hlookup formula referencing multiple tabs to create summary tab
    By kgilmore in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-05-2019, 03:14 PM
  3. [SOLVED] SUMIFS,INDEX, MATCH, OFFSET COUNTA / SUMPRODUCT? Multiple criteria across multiple sheets.
    By TheKlaw in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-06-2015, 08:44 PM
  4. Referencing multiple tabs to rows within one master sheet
    By Metguy1 in forum Excel General
    Replies: 3
    Last Post: 01-17-2014, 12:37 PM
  5. Excel 2007 : Cross referencing across multiple tabs within the same workbook.
    By Crolynx in forum Excel General
    Replies: 2
    Last Post: 01-18-2010, 06:52 PM
  6. Help with a formula referencing multiple tabs
    By CIP in forum Excel General
    Replies: 3
    Last Post: 09-08-2009, 10:11 AM
  7. Dragging a formula referencing multiple tabs
    By gvb in forum Excel General
    Replies: 0
    Last Post: 03-05-2008, 02:21 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