Copy Column to relevant column by date

[cloudwalking]

Hi there,

I am wondering if someone could advise me on how to build some code for the following as I'm a bit of a novice?

Basically, In ColA I have a long list of names starting at row2 & down to 10000, In B I have the relevant date starting at row2 & down to 1000 (always the same day as lists are compiled by day).

In c1:ff1 I have an array of consecutive dates.

So up til now I have been copying A2:A10000, locating to relevant column for the date between c:ff, and then pasting. I have to do this quite a lot so is there a way of writing code so that excel will read the date in B and then automatically copy A2:A10000 and paste the data to the correct column from row2 downwards?

Any help greatly appreciated!! TIA!

[cloudwalking]

ColB is 2:10000 the same as ColA, my mistake.

[cloudwalking]

Sorry to repost, can anyone help? :s