Hello Aussiebear,

Glad you had some sleep, although 4 hours is not long really lol

I'll do my best to answer all your point as clearly as possible

Confirming there are some IF statements on the rate Calc sheet and that ActiveSheet and ActiveWorkbook.Sheets('Rate Calc") are one and the same, that's just my ham fisted way of trying to get it to work for me, sorry my bad.

Cell 3 is my primary drop down list and consists of the below:


Air
Ocean_EU_to_US
Ocean_Asia_to_EU
Overland


Cell C4 is my Secondary drop down and is dependent on what is selected from the primary dropdown (C3)


Air
Warsaw to New York
Warsaw to Los Angeles
Malpensa to New York
Malpensa to Los Angeles
Heathrow to New York
Heathrow to Los Angeles

Ocean_EU_to_US
Genoa to New York
Genoa/La Spezia to Los Angeles
Gdynia to New York
Gdynia to Los Angeles
Hamburg to New York
Hamburg to Los Angeles
FXT/SOU to New York
FXT/SOU to Los Angeles




Ocean_Asia_to_EU
Shanghai to Genoa
Xiamen to Genoa
Shanghai to Gdynia/Gdansk
Xiamen to Gdynia/Gdansk
Shanghai to SOU/FXT
Xiamen to SOU/FXT

Overland
PL to UK
UK to PL



I insert the value '"Please select Origin..' into cell C4 so its a prompt to tell the user to select from that drop down, it also serves another purpose in that, if that is displayed in C4 then my Rate Calc fields are all blank otherwise I get odd data appearing in the main rate calc sheet.



I am bastardising this Rate Calc from another customer of mine and so some of the actual lines that are showing hidden/unhidden/clear etc will be incorrect, this I'm not concerned with as I will clean this up once I understand how to incorporate the Case statements alongside the additional IF statements.

There will be some cross over between what is asked to be hidden and what is asked to be shown, based on what is selected in the primary drop down C3 and then further hidden/reveal requests when the secondary drop list activated.
for example when Air is selected I don't need to show rows 23 to 25 as these are container information that is only used for Ocean movements.

If its easier i can share the actual document, once i work out how to attach it to this forum, i looked at all the icons but couldn't see once for attaching something, only for inserting an image or a video, no documents

Once again thank you for you help and patience