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!

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

"GemznJewlz" <GemznJewlz@discussions.microsoft.com> wrote in message
news:688FB2C4-1651-4CE6-A486-7474DC852109@microsoft.com...
> 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!

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"
<GemznJewlz@discussions.microsoft.com> 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!