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