Moving data from sheet to sheet using a drop down menu

Willikins88

New Member
Joined
Jun 27, 2018
Messages
2
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
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Osvaldo Palmeiro

Well-known Member
Joined
Feb 24, 2009
Messages
559
Office Version
  1. 365
Platform
  1. Windows
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).

Code:
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
 

Watch MrExcel Video

Forum statistics

Threads
1,109,248
Messages
5,527,627
Members
409,777
Latest member
jamilowella

This Week's Hot Topics

Top