Hi I am trying to save some time Cut and Paste.
I have values as follows for each month
Col A Col B
Jan 5.15
Feb 3.20
-
Dec 6.75

I then have a 100 years of daily data
Col X Col Y
1 Jan 1900
2 Jan 1900
3 Jan 1900
-
31 Dec 1999

I want to apply the value for January (5.15) to Col Y for 1-31st January
00-99, then same for Feb, march etc.
I need to do this fairly frequently to copy into another program.

Probably a simple answer, I have used VLookup before but cant get it to work
for this.

Many thanks
Chris