+ Reply to Thread
Results 1 to 3 of 3

Fill in data in other tabs based on data in this tab

  1. #1
    Registered User
    Join Date
    06-01-2010
    Location
    MA, USA
    MS-Off Ver
    Excel 2013
    Posts
    18

    Fill in data in other tabs based on data in this tab

    I have >1,000 rows of data that looks like this:
    A B C
    1 420 499
    6 418 499
    8 425 495
    I need a way to update the data in other tabs labeled "1", "2", etc. based on the data in A, such that my "1" tab should have this in it:
    A B
    420 499
    My "6" tab has this:
    A B
    418 499
    And my "8" tab this:
    A B
    425 495
    And I need all the data updated on the fly, and the rows will almost never be sorted based on any column. The data contained in tabs "1" through "10" is used to create mapping information, and it has to be separate from the data in the "Main" tab. Is there a formula I can add to my "Main" tab that will parse down through all the rows and update the remaining tabs with new data?

  2. #2
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: Fill in data in other tabs based on data in this tab

    You could have formulas that reference the Main worksheet

    For example: In tab1 have a formula like this =+Main!A1

    Now when the main tab is updated so is tab1

    Do the same for all of the other tabs(worksheets)
    Click on star (*) below if this helps

  3. #3
    Registered User
    Join Date
    06-01-2010
    Location
    MA, USA
    MS-Off Ver
    Excel 2013
    Posts
    18

    Re: Fill in data in other tabs based on data in this tab

    Each tab needs unique data, so in the "1" tab I have to have only those rows in "Main" that have a "1" in Column A, and the rows in "Main" will never be sorted on Column A, so the formula needs to handle random data. And the data in "Main" will get resorted regularly on columns other than A, B or C, so the formula needs to handle the data changing while not adding duplicate data to the "1" through "10" tabs.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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