WOW.

Thank you all so much for taking the time to look at
this. I am using Rockys solution because I sort of
understand it a little. :) And I am trying to learn new
ways to replace pulling down formulas through 5,000 -
10,000 rows of data per sheet. If anyone knows an
alternative to pulling down 30 columns of formulas through
10,000 rows of new data, please, please, please let me
know.

Regards, Tim

-----Original Message-----
Hi,

Can you show me how to write a macro to convert a three
place month abreviation, Jan, Feb, Mar, etc., in column Y
into a number, 1, 2, 3, etc., in column AF?

Thank You.

Regards, Tim
.