You are here:
Hi Greg, In order to sort it automatically, you will need to use VBA macro to capture worksheet events. However, it may not be efficient if the worksheet contains large amount of data. Let me know
As a function, it should have something stored in a variable called FF, and to VB you have a lot of undeclared variables - which SEEM to relate to fixed cells - so I THINK this should be a macro - but
What do you need to do exactly? Link one cell at a time, or sum all of them? The procedure you describe would work for the first case, while for the second you could do something like: =SUM(Sheet1:Sheet5!A1)
All of those are impossible for me to answer since I don't know how PC literate you are, how fast you understand new topics, how proficient you are in EXCEL, etc. It could take you a weekend of learning
Mike Trapp, Trend and Forecast worksheet functions use the same algorithm (least squares). Forecast will give you the estimate for the next month. Trend can do more than the next month, but since

©2009 About.com, a part of The New York Times Company. All rights reserved.