month to number
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 . |
All times are GMT +1. The time now is 03:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com