Hi,
I'm looking to rename and save my workbook to a destination file everday at a preset time. After it saves to the destination file i need all the data to be removed from the origional workbook.

Lets say I'm working with a workbook called Book1 everyday at lets say 3:00 p.m. it saves that Workbook to a destination file along with todays date. Example Book1_8_21_06. Then once saved all data is removed from the origional workbook.

Is this acheivable?

Mike