Is there a way I can get Excel to multiply every 2 cells in a given row? The
difficulty being that it needs to multiply as the data is entered, not by
running a macro after all data entry is finished.

For instance, I want to be able to enter in A and total in B:

A B

2
2
4

3
2
6

etc

Is it possible to set this up as a seperate form, where the sum of column B
goes into the cell the form is opened from?

Thanks,

Dave