Hi, I wonder if any one can help I have a sheet that has rows of dates in
that look like this
31 October 2009 26 December 2009 20 February 2010

What I would like to do is highlight the row and transfer the dates into
another sheet but in monthly order, so any date with January 2009 in it would
go in the first column marked January and any date with February 2009 in it
would go into the next column marked February and so on. I hope this makes
sense, Can it be done?

Thanks in advance, Barry.

Copy the row to another sheet.

Hightlight that row and sort left to right.

Found under DataSortOptions.


Gord Dibben MS Excel MVP

On Sun, 23 Aug 2009 11:33:01 -0700, Barry
wrote:

Hi, I wonder if any one can help I have a sheet that has rows of dates in
that look like this
31 October 2009 26 December 2009 20 February 2010

What I would like to do is highlight the row and transfer the dates into
another sheet but in monthly order, so any date with January 2009 in it would
go in the first column marked January and any date with February 2009 in it
would go into the next column marked February and so on. I hope this makes
sense, Can it be done?

Thanks in advance, Barry.

Spot on, and so simple Thanks.

"Gord Dibben" wrote:

Copy the row to another sheet.

Hightlight that row and sort left to right.

Found under DataSortOptions.


Gord Dibben MS Excel MVP

On Sun, 23 Aug 2009 11:33:01 -0700, Barry
wrote:

Hi, I wonder if any one can help I have a sheet that has rows of dates in
that look like this
31 October 2009 26 December 2009 20 February 2010

What I would like to do is highlight the row and transfer the dates into
another sheet but in monthly order, so any date with January 2009 in it would
go in the first column marked January and any date with February 2009 in it
would go into the next column marked February and so on. I hope this makes
sense, Can it be done?

Thanks in advance, Barry.