Code to move data from one table to another by clicking a button

What I am trying to accomplish is enter series of data into a table (column B&C). That table will get a total volume and calculate a weighted average (B13 & C13). I will then select a state from a drop down list (A13). Then I will click the macro button that will take the state selected from the drop down list and find it in the historical table. Then transfer the volume, low value, high value and weighted average value to the historical table (column G-K).

I would like to have this done in a macro that I can attach to the blue button "Move" in the center of the worksheet.

Any help you could provide would be greatly appreciated.

Thanks for the help

Marvin and Yasser,

Thank you both for your assistance. I did notice the error and was able to decipher where the correction needed to be made. The nuts and bolts of the code were exactly what I needed. I have just enough experience that I was able to make the change.

Again thank you both for taking the time to assistance. This forum is an outstanding tool.