Business Software

Recent Answers

2009-11-08 Excel - count if:

Bill I am not sure that I am reading the question correctly but-- You can use data validation to create your list of criteria that go in a cell that is referenced in your count formula. Then when

2009-11-08 Excel - Hiding rows with blank value:

I assume your dropdown is done using the List option from data validation. If so, you can react to a selection by using the worksheet change event. Right click on the sheet tab and select view code

2009-11-07 Excel - Hiding rows with blank value:

Sian, Let's assume that column B can be used to determine which rows are blank - i.e. if a cell in column B is blank, then the row needs to be hidden. Assume that values in column B are constants and

2009-11-07 Excel - Calculations using Visible results of other Calculations:

IAN, Based on your stated sitation and needs, I would recommend making the stored value and the displayed value by altering your formula to use the round function Y5: =(C5/100)*G5 becomes

2009-11-07 Excel - VBA Formula:

use the CHANGE event of the worksheet to handle the macro (vba editor, click the worksheet, change the dropdown from GENERAL to Worksheet - you should the see the change event. It is possible to restrict