05-03-2005, 09:01 PM
Does anyone know how to create a macro that
1. Archives the data from a particular worksheet to another file
2. Clears the data out of the sheet when done?
If you could help I would be most greatful.
Have this school project and trying to Jazz it up a bit.[/list]
1. Archives the data from a particular worksheet to another file
2. Clears the data out of the sheet when done?
If you could help I would be most greatful.
Have this school project and trying to Jazz it up a bit.[/list]