+ Reply to Thread
Results 1 to 3 of 3

Matching entries on separate tabs ...

  1. #1
    Registered User
    Join Date
    03-06-2015
    Location
    Denver, CO
    MS-Off Ver
    2010 & 2013
    Posts
    47

    Matching entries on separate tabs ...

    I have attached a file that I am working on ...

    I am on the tabs DashBoards and Trends ...

    in the upper left corner on both tabs there are 3 Option boxes for data: Week #, Month and Quarter #

    I want to be able to change the box on EITHER tab and have both of them equal each other (if that makes sense) ... so, I want to be able to make a change to Week # on the DashBoards tab and have that change simultaneously on the Trends tab ... and vice versa .. if I make a change on the Trends tab, ... I want that change to be made simultaneously on the DashBoards tab ...

    I'm not sure if it matters but all three of the selection boxes are tied to data validation which is on a 3rd tab: Data Set-Up ... if that matters ...

    thank you for helping ...
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: Matching entries on separate tabs ...

    You'll need to look into VBA for that, since this would create a circular reference.
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  3. #3
    Registered User
    Join Date
    03-06-2015
    Location
    Denver, CO
    MS-Off Ver
    2010 & 2013
    Posts
    47

    Re: Matching entries on separate tabs ...

    bummer ... thx ... I don't want to head that direction ... I will just have to keep the data Choice on the one tab ...

+ 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. Moving multiple excel tabs into separate tabs/separate files
    By RO24 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-02-2014, 11:04 AM
  2. separate the data from the 25 entries on the master to separate worksheets
    By nemo12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-21-2012, 09:27 AM
  3. Separate Categories into Tabs
    By nicholasoh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2011, 02:20 AM
  4. Replies: 3
    Last Post: 03-16-2010, 08:43 AM
  5. Separate tabs from a spreadsheet
    By ukphoenix in forum Excel General
    Replies: 2
    Last Post: 11-30-2009, 02:35 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1