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
Bookmarks