Macro question... (maybe Scripting?)

[Ice5]

First of all, the worksheet in question can be seen here:
http://www.cameronspencer.com/semester5.html

I added the column and row headers (abc, 123, etc.) so everyone knows what's what.

Basically I'm looking for a formula to figure out how many dual flights, solo flights, etc. I haven't done yet.

Pseudo code:

dual_flights_remaining = 0;
for(i<=30,i=1,i++) {
  if (("I"+i == "") && ("B"+i<>""))
    dual_flights_remaining++;
}

Then cell L22 would be "=dual_flights_remaining"

I'm assuming this would be accomplished with VB Scripting?

Thanks.

EDIT: Fixed the URL.
This message was edited by Ice5 on 2002-09-19 17:42

 

[Ice5]

Please ignore.
Problem solved.

 

[Joe Was]

I need more information. I have looked at your sheet and each flight has a Dual or Solo?

What's all the strike-through's?

Do you have the total needed for each?
Or is the total dynamic and increasing?

In any case, I think you can use sheet formulas or a Change Event Macro to update the remaining fields on any sheet change.

I looked and looked at your sheet and am having a problem understanding? JSW

_________________<INPUT type="JSW" value=" Excel On... Coder's!" ID=Text1><spanstyle='font-size:36.0pt;color:#FFCC00'>JSW<o></o></span>[/b]</p><spanstyle='font-size:36.0pt;color:#FFCC00'>Try and try again, " The way of the coder!"<o></o></span>[/b]
This message was edited by Joe Was on 2002-09-19 18:33