Thread: Data pull from other sheet as per selection on DropDown List

Hi,

Please find attached the Data format file.
I have some data in sheet1 and in sheet2 i have create a Drop Down list on cell A1 with the name of team lead. what i want if i select any TL Name then all data will pull from sheet1 for respective Team lead only.

I want to do this task with the help of macro.

So please help me out.

Thanks
Abdul Haneef

Hi Abdul Haneef,
The example file is not attached

Hi
Now i have attached the example format file. please help me out.

Thanks
Abdul

Hi Abdul Haneef
in the worksheet two module place

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    Dim myRange As Range
    On Error Resume Next
    Set myRange = Intersect(Range("A1"), Target)
    If Not myRange Is Nothing Then
          Worksheets("Sheet2").Range("A4:D" & Worksheets("Sheet2").Cells(Worksheets("Sheet2").Rows.Count, 1).End(xlUp).Row).ClearContents
    With Worksheets("Sheet1")
        .Range("A1:D" & .Cells(.Rows.Count, 1).End(xlUp).Row).AutoFilter Field:=2, Criteria1:=Worksheets("Sheet2").Range("A2").Value
        .Range("A1:D" & .Cells(.Rows.Count, 1).End(xlUp).Row).SpecialCells(xlVisible).Copy ThisWorkbook.Worksheets("Sheet2").Range("A4")
    End With
   End If
End Sub

Finnaly the thing attached

Example Format test.zip