Microsoft Software

Recent Answers

2009-11-07 Excel - Using formulas to sort rows of data automatically:

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

2009-11-06 Excel - VBA Formula:

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

2009-11-06 Excel - Excel:

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)

2009-11-06 Excel - Auto date change when changes have been made to spreadsheet:

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

2009-11-06 Excel - Excel 2007 Trending or forecasting:

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