Adding total and trasfering line in other sheet....

... with a macro is possible to summ the value into range ( G3:L.... ) identify from the index into column C and trasfering the line of summ into sheet TOTALE...

Example:
i have insert the index CB450021 (range of summ G3:L11) and CB450022 (range of summ G12:L18) the related summ into sheet TOTALE, the next line is refered from CB450023, ecc...

Hope understand me...

here the file:http://www.mytempdir.com/505626

to be honest with ya, i hardly can. but anyway, can you expound more of the problem

Quote:

---

Originally Posted by luca90

Hope understand me...

---

Not much. Maybe you want to do something like this ?

Code:

---

Private Sub CommandButton1_Click()
  Cells(4, 1).Formula = "=SUM(A1:A3)"
  Worksheets("Sheet2").Cells(1, 1).Value = Cells(4, 1).Value
End Sub

---

Excel VBA question moved to office development