Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I fill data in a list automatically? | Excel Discussion (Misc queries) | |||
Master worksheet automatically enters data into sub worksheets | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
How do I transfer data between Excell sheets? | Excel Worksheet Functions |