repeating a formula

  • Thread starter Thread starter mijoda
  • Start date Start date
M

mijoda

I am creating a simple inventory that will include an item count column
and a price column. I want to total the dollar amount for each row and
then have a grand total for all of the inventory. How can I create a
formula for the row subtotals without having to re-enter the formula in
each row? Thanks:)
 
Enter the formula in say H1, and then move the cursor to the bottom right
corner until it changes to a black square, click and drag the formula down.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You might want to modify this macro to suit. Assign to button/shape.

Sub balance()
Set frng = Range("h8:h" & Range("a65536").End(xlUp).Row)
With frng
.Formula = "=h7+d8"
.Formula = .Value
End With
End Sub
 
Back
Top