Which members have a birthday today?

Hi adofp,

This code is untested:

Sub BDays(): Dim ws As Worksheet, wo As Worksheet
Dim Mo As Long, Dy As Long, e As Long 'the data columns and the extent of one of them
Dim i As Long, j As Long, D As Date: D = Date: 'Mo=MonthColumn:Dy=DayColumn:  'i,j row indices
e = ws.Range("R" & Rows.Count).End(xlUp).Row 'Change the "R" to an appropriate column
Set ws = Worksheets("Sheet1"): Set wo = Worksheets("Sheet2")
For i = 1 To e
If ws.Cells(i, Mo) = Month(D) And ws.Cells(i, Dy) = Day(D) Then
j = j + 1: ws.Cells(i, Mo).EntireRow.Copy wo.Cells(j, 1)
End If: Next i: End Sub