making a cell recalculate as data is entered in rows
Posted by Warren on November 04, 2000 1:26 PM
Here is some simple data in a spreadsheet:
A B C D E
1 20 4 5 5 20
2 20 5 4 9 40
The spreadsheet is set up such that each row remains blank until I input a number into column B of that row. Suppose I want cell A50 to diplay the result of E2/D2 after I input a number in B2. What function or macro can I use to make A50 automatically calculate E3/D3 after I enter a number in B3 and so on for Row 4, Row 5, Row 6 etc?