Purge or transfer old data automatically?
 

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!

Purge or transfer old data automatically?
 

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!

Purge or transfer old data automatically?
 

Formulas can only return results to the cell in which they are written.

They cannot purge or transfer data.

Give us a description of your needs.

There are other methods.


Gord Dibben Excel MVP

On Fri, 18 Nov 2005 08:40:03 -0800, "GemznJewlz"
wrote:

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!