Excel : dividing two cells 2

[natedeia]

I am having trouble, too many mistakes to paste here.
Problem: Column A has a four digit # added each day. That # is divided by the cell next to it (ie: =A6/B6)which the outcome goes into cell A100. It is done manually every day, along with a million other things. Each day the cell below the last gets updated and I wanted to have a way to have cell A100 to automatically update once the the new # is entered in column A. The info is already in column B.
Is this possible to have that one cell update A100 if all the other cells have the same formula?

 

[ETID]

in cell a 100...


=INDIRECT("A"&COUNT(A1:A99))/INDIRECT("B"&COUNT(A1:A99))

 

[01Patrik]

Very nice solution... I was thinking along the lines of a worksheet change - event. But your way once again shows that most tasks can be done without using code. Have a shiny one

// Patrik
______________________________

To the optimist, the glass is half full. To the pessimist, the glass is half empty. To the IT Professional, the glass is twice as big as it needs to be.

 

[natedeia]

great, thanks so much, i was going a whole different direction with that one, with worksheet updates and more...
i hope to use your solution for other tasks too, thanks again.