I think you need in Data- filter - auto filter or advance filter. I don't
know if you want to copy from column x to column A just the January values,
or if you want to reference the values in column X. I think you want to copy
column X using the advance filter. The advance filter would be month() = 1

"diver_sol" wrote:

Thanks for your replies, im just a bit confused, how does those
forulae work exactly?

I have my dates in Column X7:X100

I have a 'January' column starting at A5. I want to display all the
January dates in X7:X100 in a list starting at A5, all the feburary
dates in a list starting at B5 etc etc .

Could you explain your answer in a bit more detail?

Thanks a lot