+ Reply to Thread
Results 1 to 5 of 5

Dynamic reference to table

  1. #1
    Forum Contributor
    Join Date
    01-25-2021
    Location
    Atlanta, Georgia
    MS-Off Ver
    365
    Posts
    110

    Dynamic reference to table

    Good morning,

    Can a table be referenced to another table so that it resizes when source table does?

    As in the attachment, new data is added to SOURCE table in row8, DUPLICATE table should also expands to row8.....
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,279

    Re: Dynamic reference to table

    I doubt you can do it automatically with a second structured table. But you could do it with the new dynamic FILTER function.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,279

    Re: Dynamic reference to table

    Or better:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    01-25-2021
    Location
    Atlanta, Georgia
    MS-Off Ver
    365
    Posts
    110

    Re: Dynamic reference to table

    How will I be able to have the output go into a table......I get SPILL error when I convert it

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,279

    Re: Dynamic reference to table

    How will I be able to have the output go into a table
    You can't.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Dynamic reference of table column in VBA
    By shashankgupta22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-26-2021, 07:10 AM
  2. Named ranged with reference to second row in dynamic table
    By jaryszek in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-04-2018, 05:18 AM
  3. [SOLVED] Named range and reference to one cell within dynamic table
    By jaryszek in forum Excel General
    Replies: 9
    Last Post: 03-22-2018, 07:04 AM
  4. Restructure data table using Index and dynamic cell reference?
    By dpete1510 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-29-2017, 05:47 PM
  5. Dynamic reference to Table Column header
    By aiyathomas in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-08-2017, 10:30 PM
  6. Pivot table to reference a dynamic range on another sheet
    By Chumpalot in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-30-2014, 09:19 AM
  7. Dynamic reference table from a table source
    By Sailor61 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-13-2013, 10:02 AM

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