I am at loss as to what is indicated here.Exactly where do I put the code? I
am not good at spread sheets . Where is the code page behind the spread
sheet? I have been working on this "simple thing" for days".

What I am doing is adding sales up for a whloe year, I have about 100 items
that I sell and wish to add up the totals.

Item 1 sold cost total
**
Item 2 sold cost total
**
the ** is where I want to enter amounts to wind up in the total area.
Thanks
chuck




"AlfD" wrote:


Hi!

Try this in the code page behind your worksheet (I've called it
Sheet1):

Private Sub Worksheet_Change(ByVal Target As Range)
With Worksheets("Sheet1")
.Range("A2") = "=" & .Range("A1")
End With
End Sub

Each time you change A1, its calculated value will appear in A2.


Alf


--
AlfD
------------------------------------------------------------------------
AlfD's Profile: http://www.excelforum.com/member.php...fo&userid=4785
View this thread: http://www.excelforum.com/showthread...hreadid=468361