Formulas don't purge or transfer. You'll need a macro.
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"GemznJewlz" wrote in message
...
Is there any way to insert a formula into Excel that will automatically
purge
or transfer data into another spreadsheet? It would be so much more time
efficient.

Thanks for any help!