+ Reply to Thread
Results 1 to 5 of 5

control (vice versa) by the same drop down list on different sheets

  1. 08-24-2016, 07:35 AM #1
    abubader
    abubader is offline
    Registered User
    Join Date
    03-12-2013
    Location
    Jordan
    MS-Off Ver
    Excel 2007
    Posts
    5

    control (vice versa) by the same drop down list on different sheets

    How to show the same value on each drop down list on every sheet
    I have drop down list (by data validation list feature) on sheet # 1, and also have the same drop down list on sheet #2, I want when I select value from this drop down list on sheet 1, the value of the drop down list on sheet 2 will be change automatically and vice versa
    Attached Files Attached Files
    Last edited by abubader; 08-24-2016 at 07:43 AM.
    Reply With QuoteRegister To Reply
  2. 08-24-2016, 07:55 AM #2
    TMS
    TMS is online now
    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
    44,613

    Re: control (vice versa) by the same drop down list on different sheets

    You'd need VBA to do that. Workbook level worksheet change event handler.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    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

    Reply With QuoteRegister To Reply
  3. 08-24-2016, 08:08 AM #3
    abubader
    abubader is offline
    Registered User
    Join Date
    03-12-2013
    Location
    Jordan
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: control (vice versa) by the same drop down list on different sheets

    can you please help me
    Reply With QuoteRegister To Reply
  4. 08-24-2016, 09:02 AM #4
    TMS
    TMS is online now
    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
    44,613

    Re: control (vice versa) by the same drop down list on different sheets

    Yes, but it may take a while as I'm away from home and my computer.
    Reply With QuoteRegister To Reply
  5. 08-24-2016, 03:59 PM #5
    TMS
    TMS is online now
    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
    44,613

    Re: control (vice versa) by the same drop down list on different sheets 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatically updating cells on different sheets when one cell is updated and vice versa.
    By DanDan155 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2016, 03:41 PM
  2. Capturing of date and time whenever a long list of 1 changes to 0 and vice versa
    By S.S.LIM in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-27-2015, 05:00 PM
  3. A clever way to pass lot of ranges from the sheets to VBA and vice versa
    By TopXorGuy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-07-2013, 02:49 PM
  4. UserForm to Worksheet and Vice Versa
    By ffffloyd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2011, 02:23 AM
  5. How do I Replace - with + and vice versa
    By hb2474 in forum Excel General
    Replies: 2
    Last Post: 11-11-2005, 03:15 PM
  6. Outlook task from xls or vice versa
    By wahur in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-26-2005, 09:37 AM
  7. Can I rotate excel sheets so columns are rows & vice-versa (i.e..
    By JamesR in forum Excel General
    Replies: 3
    Last Post: 01-12-2005, 10:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1