Need to Select Individual Records Based on Birthdays in Current Mo
Assuming birthdates are in column C
In a helper column enter =MONTH(C1)
Copy down.
Autofilter on Month number..........9 is October.
F5SpecialVisible CellsOK
Copy and paste the visible cells to somewhere.
Gord Dibben MS Excel MVP
On Wed, 7 Oct 2009 13:53:02 -0700, PlarfySoober
wrote:
That sort of says it. I need to create a list, probably on the same sheet,
with the names & birthdays of everybody whose birthday, e.g., falls in
October.
Trying to do it by hand is embarrassingly inaccurate.
Any suggestions would certainly be welcome.
Don.
|