+ Reply to Thread
Results 1 to 2 of 2

Help Creating Referenced List

  1. #1
    Registered User
    Join Date
    10-22-2020
    Location
    Florida, USA
    MS-Off Ver
    Microsoft Office 365 Version 2002
    Posts
    1

    Help Creating Referenced List

    Hello,
    I have several lists of values that occur in a certain order and, once they start, they occur every year until the list is complete. I want to create a summary table that will automatically populate based on the year that each list starts and will update if I change the start year. I have an example with sample data values on the first tab and the summary table I would like to make on the second tab. In this example, if I were to change Variable B to start in starts in year 3, I would like the table to automatically adjust so the first release is on YR3 instead of YR2.

    Thank you!!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Help Creating Referenced List

    Hi

    please try this in C3 and across:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Limor_OP; 10-22-2020 at 03:56 PM.

+ 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. creating a list from cross referenced data
    By gassiusmax in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-19-2018, 02:22 AM
  2. [SOLVED] How to prevent Excel from creating a zero in a blank cell when referenced
    By Dlinen in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 06-07-2016, 12:45 PM
  3. Creating referenced table
    By chewytoy in forum Excel General
    Replies: 1
    Last Post: 03-18-2015, 09:43 AM
  4. Replies: 3
    Last Post: 03-02-2015, 03:23 PM
  5. Creating & Using a global variable referenced by many worksheets within a workbook
    By number6 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2009, 07:18 PM
  6. List of Tabs/files being referenced?
    By cdnorman79 in forum Excel General
    Replies: 0
    Last Post: 06-12-2008, 12:17 PM
  7. Validation List from 2 or more referenced cells
    By HuskerBronco in forum Excel General
    Replies: 4
    Last Post: 12-14-2006, 09:39 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