+ Reply to Thread
Results 1 to 3 of 3

Resetting drop menu's

  1. #1
    Registered User
    Join Date
    11-01-2009
    Location
    Deerlijk, Belgium (currently Switzerland)
    MS-Off Ver
    Excel 2007
    Posts
    4

    Resetting drop menu's

    Hello,

    I'm a bit playing with excel and I've encountered a problem.
    I'll explain the problem with the included excel-file. (Don't allow the macro as this macro is not required for this problem)

    The sheet where I have the problem is sheet 'army movement'

    If I change the country in cell B2, I would like to have that the cells D2, E2 and F2 show the same name as cell R2. (This is always the first option of the drop menu's)

    Cells D2, E2 and F2 are made by using the validate option in order to get drop down menu's.

    The source information is in the hidden columns I-Z.

    So for example:
    if I change cell B2 to Belgium, I would like to see that D2, E2 and F2 also show Belgium immediately. I can then select the place I want to move from Belgium to by using the drop menu in D2 (for exampla Belarus).

    As I selected for D2 Belarus, this has to be shown in E2 and F2 also.
    I can now select E2 (for example Austria).

    If Austria is selected in E2, I want to see this also in F2.

    To recapitulate:
    If I select Belgium as starting place, I want to see in movement 1,2 and 3 also Belgium, as there hasn't been anymovement yet.
    If I let my army go from Belgium to Belarus, I want to see for the two remaining movements Belarus (as this means that the army remains in Belarus)
    If I let my army go forward after Belarus to Austria, I want to see in the last movement phase Austria (no movement). If I still want my army to move I can still adapt it.

    The idea is that the starting place will also be automated later. And if I do nothing, there has to be no movement, so the result in F2 needs to be the same as E2, which is the same as D2, which is the same as B2.

    Please note that the countries are not geographically correct as I just copied the list of names from the internet and tagged them to the locations at random.

    Thanks in advance.

    Sincerely,
    Bjorn
    Attached Files Attached Files
    Last edited by Dreekenkorin; 11-01-2009 at 07:40 PM. Reason: Problem solved

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Resetting drop menu's

    This is a worksheet event macro:
    Please Login or Register  to view this content.
    =========

    1) Right-click the sheet tab
    2) Select View Code
    3) Paste in the macro above
    4) Close the editor and save your sheet

    Now any changes made to column B will be reflected in D, E and F on the same row.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    11-01-2009
    Location
    Deerlijk, Belgium (currently Switzerland)
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Resetting drop menu's

    Thank you. Didn't know worksheet had their own macros.

+ 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