R
Rod Fordham
Here's what I'm trying to do...
I want a macro that will take a date value from a cell (say B2 on sheet1)
and compare it to a list of closing dates (month's end closing). It needs
to then make folders for the year and month (if they don't already exist)
and save the file in that folder.
The sheet with the closing dates is setup like this:
Month Ending Fiscal Year
November 11/28/04 2005
December 12/31/04 2005
And so on...
Thanks for the help up front!
I want a macro that will take a date value from a cell (say B2 on sheet1)
and compare it to a list of closing dates (month's end closing). It needs
to then make folders for the year and month (if they don't already exist)
and save the file in that folder.
The sheet with the closing dates is setup like this:
Month Ending Fiscal Year
November 11/28/04 2005
December 12/31/04 2005
And so on...
Thanks for the help up front!