I have a spreadsheet which I save with a different number every month
i.e 0601,0602 and so on. Im trying to set a macro up so it
automatically saves the file and increases the number by one so it dont
overwrite the existing file.

Anyone any ideas how I can do this.

Many Thanks


--
shrek