Moving data from sheet to sheet using a drop down menu

[Willikins88]

Hi all, new to here but I need some help and was told that you guys may be able to help me. Essentially I am trying to move data from one sheet to another in the same work book, but in a particular way and my coding skills are little to non existent. Essentially I have a drop down with weeks numbered 1-52 in Cell F3 in sheet MW.

What I am looking to do is when I select a number from this drop down for it to pull data out of another sheet (TA) into this one. So for example, if I choose 1 in F3 in sheet MW I need it to copy the data from B4-B14 in Sheet TA and copy it to Cells o7-o17 in sheet MW. The o7-o17 in MW is constant however the source would change to c4-14 for "2", d4-14 for 3 and so on (all in TA).

I really hope you can help me as I am really struggling with this and I would be super grateful

 

[Osvaldo Palmeiro]

Hi. Try this code. It goes into the sheet MW module (right click the tab of that sheet / choose View Code to open it's module).

Private Sub Worksheet_Change(ByVal Target As Range)
 If Target.Address <> "$F$3" Then Exit Sub
 [O7:O17] = Sheets("TA").Cells(4, [F3] + 1).Resize(11).Value
End Sub

 

[Willikins88]

Unfortunately that does not seem to work it it isn't pulling any info over :/

 

[Osvaldo Palmeiro]

It works for me. What exactly have you done?