VBA copy/paste cells based on dropdown selection

[Mmcq16]

Hello

I have two sheets that I am using. sheet 2 has a list of experiments in column C with information regarding the experiment in columns F - J. On sheet 1 I have a dropdown box with a list of all the experiments. When I select an experiment from the dropdown box I would like to populate columns K - O on sheet 1 with the information from columns F - J for the selected experiment on sheet 2. Is this possible?. Any help would be apprecicated

-
Mike

 

[Mmcq16]

That did not work however I solved the problem by adding a userform. Thank you for all your help.

 

[mumps]

My pleasure.