Hi Nicole

You can add a helper column with
Month(a1) and sort on that column

You can try EasyFilter to copy(not formulas) the cells to a new sheet
http://www.rondebruin.nl/easyfilter.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Nicole D" <Nicole wrote in message ...
I have a master spreadsheet that has a list of people with dates
corresponding to each person. I want to link all of the January dates to a
January sheet, Februaty dates to a February sheet, so and so forth. The
dates are not in order, and I am using an =IF formula to bring them over to
each corresponding sheet. The problem is that when they are in the
corresponding sheet, they are being brought over in the row number that they
are in on the master sheet, which leaves several spaces between entries based
on the number of people there are bewteen similar months. I'm sure I am
making this more confusing than it should be, but I need help with how I can
do this easier. Thanks.