Choronzon
Power Member
- Apr 20, 2008
- 553
- 381
Is there anyone who is good with excel macros that can help me out.
I have a spreadsheet with all of my data in and I am trying to automate it with a macro so that at the end of the week it will save the spreadsheet to an archive somewhere as a seperate workbook (preferably with a filename based on the current date) and then clear the sheet ready for the next weeks data.
Can anyone help me with a solution or even just point me to a place where I might find a solution, I have searched G00gle up and down and can't even find anything close.
I have a spreadsheet with all of my data in and I am trying to automate it with a macro so that at the end of the week it will save the spreadsheet to an archive somewhere as a seperate workbook (preferably with a filename based on the current date) and then clear the sheet ready for the next weeks data.
Can anyone help me with a solution or even just point me to a place where I might find a solution, I have searched G00gle up and down and can't even find anything close.