VBA to chose format from one column & speed from different column

[dinkss]

Hi there,

I have excel sheet data created with VBA, and simple dropdown menu list to chose different formats.
But I would like to have an option to select format and then the line speed for selected format would show on cell on top of it.

Is there any VBA code that I could use or a simple dropdown menu list or macro? Can anyone help?

I have attached screenshots of my excel and formats with speeds.

Any help will be much appreciated.

 

[Fluff]

As that is a totally different question, it needs a new thread. Thanks

 

[dinkss]

As that is a totally different question, it needs a new thread. Thanks

OK. Will open new thread.