Business 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-07 Quicken & Other Budget/Accounting Software - Quicken Unit Sales Reports:

Hi Jay, I think I answered this question this morning, but I received it again this evening. So forgive me if you have already received it, and if you have additional questions, I am happy to answer

2009-11-06 Using MS Access - Textbox in an Update Form:

You still are making this clear. what you are saying doesn't sound logical. If you are saying that the Register Date may be the same as the Actual Date and when it us you don't want to key in the same

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)