Hi guys,

I have the following directories in each fiscal year:
\\server1\Finance\FS\Company 1\2012\Qtr 1\Apr
\\server1\Finance\FS\Company 1\2012\Qtr 1\May
\\server1\Finance\FS\Company 1\2012\Qtr 1\Jun

\\server1\Finance\FS\Company 1\2012\Qtr 2\Jul
\\server1\Finance\FS\Company 1\2012\Qtr 2\Aug
\\server1\Finance\FS\Company 1\2012\Qtr 2\Sep

\\server1\Finance\FS\Company 1\2012\Qtr 3\Oct
\\server1\Finance\FS\Company 1\2012\Qtr 3\Nov
\\server1\Finance\FS\Company 1\2012\Qtr 3\Dec

\\server1\Finance\FS\Company 1\2012\Qtr 4\Jan
\\server1\Finance\FS\Company 1\2012\Qtr 4\Feb
\\server1\Finance\FS\Company 1\2012\Qtr 4\Mar

So I have this file where in A1 I'll have a data in text format YYYYMMDD. And I want to programatically save the file in the respective month in the respect quarter in the respective year. So for example I'd have the following dates and where I'd like the file to be saved:

20120428 save in \\server1\Finance\FS\Company 1\2012\Qtr 1\Apr
20120730 save in \\server1\Finance\FS\Company 1\2012\Qtr 2\Jul
20121231 save in \\server1\Finance\FS\Company 1\2012\Qtr 3\Dec

20130229 save in \\server1\Finance\FS\Company 1\2012\Qtr 4\Feb
20130331 save in \\server1\Finance\FS\Company 1\2012\Qtr 4\Mar

20130530 save in \\server1\Finance\FS\Company 1\2013\Qtr 1\May

Do you follow? Everything between April 1 2012 and Mar 31 2013 I'd like it saved in folder 2012 in its respective month and respective quarter. You'll notice that although 20130229 and 20130331 have a year date of 2013, but for filing purposes I want them in year 2012 Qtr 4. Then 20130530 will be in Qtr 1 of 2013, and so forth and so forth.

Any ideers guys?

Ron