sorting dates in another sheet

  • Thread starter Thread starter Barry
  • Start date Start date
B

Barry

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 Data>Sort>Options.


Gord Dibben MS Excel MVP
 
Spot on, and so simple Thanks.

Gord Dibben said:
Copy the row to another sheet.

Hightlight that row and sort left to right.

Found under Data>Sort>Options.


Gord Dibben MS Excel MVP
Click to expand...
 
Back
Top