What formulas are best for sorting by date?
 

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.

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.

Where would I add the helper column....I am a little confused on how that
would work.

Thanks

"Ron de Bruin" wrote:

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.

Hi Nicole

If you use a column in your data table with this formula
=Month(a1) if column A have the dates in them
and copy this formula down you can use autofilter (DataAutofilter) on that column
to filter on the month number.

You can copy the visible cells to another worksheet then

Select the rows
F5
Special
Visible cells only
Ok
Then Copy to ?

Code Example : http://www.contextures.com/xlautofilter03.html#Copy


But try EasyFilter also (very easy then)
http://www.rondebruin.nl/easyfilter.htm


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



"Nicole D" wrote in message ...
Where would I add the helper column....I am a little confused on how that
would work.

Thanks

"Ron de Bruin" wrote:

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.