Dear All, I have a following dilemma:
I need to create multiple files from a single file while automatically changing one cell.
the file is called "Property1 20100931"
Sheet1!J3 contains date let's say 9/31/2010
I need to create 30 files with decreasing date i.e.
changing DATE in Sheet1!J3...