Extract data from one worksheet to another based on selection in drop-down menu

Hi all,

I am completely new to VBA and am trying to resolve this problem. Basically, I have an excel sheet with 3 worksheets named "Trains", "Selection" and "Station". In the "Trains" worksheet, I have the fare information for 4 types of train. In the "Selection" worksheet, I have drop down menus where I can select the train type for Station 1 to Station 5. Based on my selection of train for each station in "Selection" worksheet, I would like to auto-populate the "Station" worksheet by extracting the fare information from the "Trains" worksheet. How can I go about doing this ? Any advice would be greatly appreciated.

Thank you

Thank you so much. I really do appreciate it. Now to figure out how this code works.

Originally Posted by Mumps1

Here is the code with some explanatory comments. I hope this helps.

Please Login or Register  to view this content.

Thank you Sir!