Hi, Joel, Sorry about the delay replying the site said the questions option
was not working so I did not relise it had been posted, what I have is a
sheet ( I can call it master) in cell a2 is a list of names then in b2 a
start date then each cell after that is 56 days after the cell before, what I
would like to do is look at all the dates in row 2 and copy any dates that
are in january into another sheet (call it sorted dates) in the other sheet
cell a2 would be a copy of the name from a2 in the (master) then in b2
(sorted dates) I would like copy any dates from row b2 to z2 that are January
2008 and in c2 Febuary 2009 from the same range in the master sheet and so on
to December 2009 both sheets have names listed down to row 12.

"Joel" wrote:

You'll need a macro. it is pretty easy to write one but I would like you to
post some sample row of the data. Your explanation doesn't clearly specify
everything I would need to write the macro.

"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
There are several rows and they are all have a persons name in the first
cell A1 and a start date in the next A2, the other rows are populated with
dates in two monthly intervals now because the start dates are all different
they are really hard to read each month, What I would like to do is open a
new sheet ( call it dates in order) and have 13 columns first one with a list
of names and then the next 12 the months of the year, then I would like to
transfer all the dates for January 2009 from the first sheet into the column
headed January against the original name that is was linked to in the first
sheet and so on, I would then make another sheet for 2010. I hope this makes
sense, Can it be done?

Thanks in advance , Barry.