Help Required - Logistics Optimization

[Aaditya Hamine]

Hi all !
Good Morning ! Hope you are doing fine.

Need your help in one of the issues related to Logistics.

I have uploaded the File herewith mentioning all the details.

Kindly go through it and please have your feedback.

Please refer both the sheets for better understanding.

Thanks,
Aaditya

 

[vletm]

What has changed from this?
http://forum.chandoo.org/threads/logic-for-logistics.27183/#post-162756

 

[Aaditya Hamine]

Hi !
I have added few fields - like Pick up day , Sailing Day for specific country . So that user will have this information handy with him - which can be used for better planning.

Apart from this - I could not understand the VB Code . Can you do me a favour by putting comments - at least for important stages of your code.

Thanks,
Aaditya

 

[vletm]

Hmm ... quickly checked ...
just those name has changed
and
where is CBM?

Sheet1:
There are still Your instructions how to use this:
1) Select Country
2) Select Pick up date
3) Enter CBM

Sheet2:
Shows saved informations.

datas:
Initial values

VBA comments ...
I added 'few'.
Which stages needs more comments?

 

[Aaditya Hamine]

Hi !

Values are not changing automatically even if I change the input. Can you please help ?

 

[vletm]

Did You select Country from drop down (cell [B3])?
if activecell was already [B3] then activate B4 and try again.
if still not happen then select Sheet2 and back to Sheet1.
and after that select date from drop down (cell [D3])?

... and which values didn't change?