I would use a Workbook_SheetChange macro in the Workbook module as shown
below. I assumed your 13th sheet is named "13thSheet". Come back if you
need more. HTH Otto
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Target.Count 1 Then Exit Sub
If Sh.Name = "13thSheet" Then Exit Sub
If Not Intersect(Target, Sh.Range("B3")) Is Nothing Then
'Note that Target.Value is sheet name selected
'Note that Sh is the sheet that holds the Target cell
'Note that Target.Address is B3
'Place your code here or a call to your macro
End If
End Sub
"Husker87" wrote in message
...
Hello all,
Im trying to write a macro. I have 12 identical worksheets, one for each
month of the year. Each sheet has a drop down in cell B3 with the 12
months
in it which comes from another (13th) sheet. A lot of data gets entered
into
each monthly sheet and is pretty much the same month to month. When
filling
out a new month Id like the user to be able to select a different month
with
the drop down on the current sheet they are working on and click a macro
button that would copy the values from that month to the current worksheet
they are working on. I cant seem to get the macro to recognize the value
in
B3. Help.