sorting dates in another sheet

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.
 
G

Gord Dibben

Copy the row to another sheet.

Hightlight that row and sort left to right.

Found under Data>Sort>Options.


Gord Dibben MS Excel MVP
 
B

Barry

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top