How do I filter master list to multiple sheets?

Discussion in 'Microsoft Excel Discussion' started by megandonica, Jul 19, 2012.

  1. megandonica

    megandonica Guest

    Hi,

    I am working on a spreadsheet with about 2,000 rows in the master and 9 separate tabs. In the master, I have each row color-coded for its tab but am wondering if it is possible to link a color on the master with its respective tab? The content of the spreadsheet is names and contact info.

    Thanks so much
     
    megandonica, Jul 19, 2012
    #1
    1. Advertisements

  2. megandonica

    Guest

    On Thursday, July 19, 2012 6:34:32 PM UTC-4, megandonica wrote:
    > Hi,
    >
    > I am working on a spreadsheet with about 2,000 rows in the master and 9 separate tabs. In the master, I have each row color-coded for its tab but am wondering if it is possible to link a color on the master with its respective tab? The purpose of doing this would be to color code a row in the master, and have it automatically show up in the proper tab The content of the spreadsheet is names and contact info.
    >
    > Thanks so much




    On Thursday, July 19, 2012 6:34:32 PM UTC-4, megandonica wrote:
    > Hi,
    >
    > I am working on a spreadsheet with about 2,000 rows in the master and 9 separate tabs. In the master, I have each row color-coded for its tab but am wondering if it is possible to link a color on the master with its respective tab? The content of the spreadsheet is names and contact info.
    >
    > Thanks so much




    On Thursday, July 19, 2012 6:34:32 PM UTC-4, megandonica wrote:
    > Hi,
    >
    > I am working on a spreadsheet with about 2,000 rows in the master and 9 separate tabs. In the master, I have each row color-coded for its tab but am wondering if it is possible to link a color on the master with its respective tab? The content of the spreadsheet is names and contact info.
    >
    > Thanks so much




    On Thursday, July 19, 2012 6:34:32 PM UTC-4, megandonica wrote:
    > Hi,
    >
    > I am working on a spreadsheet with about 2,000 rows in the master and 9 separate tabs. In the master, I have each row color-coded for its tab but am wondering if it is possible to link a color on the master with its respective tab? The content of the spreadsheet is names and contact info.
    >
    > Thanks so much
     
    , Jul 19, 2012
    #2
    1. Advertisements

  3. megandonica

    Don Guillett Guest

    On Thursday, July 19, 2012 5:34:32 PM UTC-5, megandonica wrote:
    > Hi,
    >
    > I am working on a spreadsheet with about 2,000 rows in the master and 9 separate tabs. In the master, I have each row color-coded for its tab but am wondering if it is possible to link a color on the master with its respective tab? The content of the spreadsheet is names and contact info.
    >
    > Thanks so much


    I would have to see the file.
     
    Don Guillett, Jul 24, 2012
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    Automatically Updating Filter in Multiple Sheets

    Guest, Jan 11, 2005, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    251
    Dave Peterson
    Jan 11, 2005
  2. GretOgrady
    Replies:
    3
    Views:
    346
    Dave Peterson
    May 20, 2005
  3. J-Mac

    Multiple Sheets Ceates Folder of Sheets & XML File?

    J-Mac, Jul 27, 2006, in forum: Microsoft Excel Discussion
    Replies:
    2
    Views:
    210
    J-Mac
    Jul 27, 2006
  4. Suzette

    Protect sheets not allowing entering of data in multiple sheets

    Suzette, Sep 25, 2006, in forum: Microsoft Excel Discussion
    Replies:
    0
    Views:
    244
    Suzette
    Sep 25, 2006
  5. Robert Jacobs

    Update Filter List AFTER Filter Applied

    Robert Jacobs, May 20, 2011, in forum: Microsoft Excel Discussion
    Replies:
    3
    Views:
    417
    Robert Jacobs
    May 23, 2011
Loading...

Share This Page