I did have this working but I want to know how

G

G Nisbet

I have a simple spreadsheet with 4 columns the first 2 columns have user
entered values.

Column 3 & 4 have "=A4*B4" & =SUM($C$4:C4)/SUM($A$4:A4) respectivly and this
works fine.

What I want is Excell to automatically add thes formula when I enter values
into row's 1 & 2. I know I could autofill the formula all the way down but I
want excell to do it as I go. As I said I did get it working but I don't know
how.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Multiple IF Statement in Word 5
Copy addition formula of non-consecutive horizontal cells 2
I have lost 6 months work, how can i get my file back 1
Getting Radio Buttons to work, that are inserted via AutoText 0
Excel does not accept text format! 0
Excel - Wich Function should I use? 1
Drop down list control value in vba 2

Top