Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GemznJewlz
 
Posts: n/a
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anne Troy
 
Posts: n/a
Default 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!



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default 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!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I fill data in a list automatically? KFuda Excel Discussion (Misc queries) 1 November 4th 05 06:36 PM
Master worksheet automatically enters data into sub worksheets Ken Excel Discussion (Misc queries) 1 November 1st 05 10:36 PM
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 12:43 AM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
How do I transfer data between Excell sheets? Grafur Excel Worksheet Functions 2 February 19th 05 03:08 AM


All times are GMT +1. The time now is 04:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"