Home

Excel Dropdwon dependent worksheet

Highlighted
Saikat Dasgupta
Occasional Visitor

Excel Dropdwon dependent worksheet

 I want to create a dynamic dropdown based worksheet where in main sheet, when i update the data, it will automatically update in the hidden sheet and using drop down menu i can see and update the data month wise .

Sub copy()

     Workbooks("LEAVE_Attendence RECORD.xlsb").Activate
     Workbooks("LEAVE_Attendence RECORD.xlsb").Sheets("Attendance Tracker").Activate
    
       If Range("D1").Value = "January" Then
            Range("C4:AG59").Select
            Selection.copy
            Sheets("January").Select
            Range("C2").Activate
            Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
        ElseIf Range("D1").Value = "February" Then
            Range("C4:AG59").Select
            Selection.copy
            Sheets("February").Activate
            Range("C2").Activate
            Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
        End If
End Sub
Related Conversations
Copy/paste no longer working in Excel
Jon Firooz in Excel on
49 Replies
EXCEL DO NOT SHOW GRAPH MAP CHART
Mark 777 in Excel on
47 Replies
align decimals in a column
Jonni Anderson in Excel on
15 Replies
Missing Excel 2013 worksheet tabs
Mike Hill in Excel on
7 Replies