Not sure if this is possible, I'm assuming it can be done with VBA, but I don't know VBA. I'm trying to create a spreadsheet that uses one cell to enter a dollar amount and stores the amount entered in another cell. But I would like the input cell be zero after each entry, and the cell storing the amounts to keep a running total. Please help Thanks
Last edited by navdad; 01-18-2012 at 01:07 AM.
It will be good if you attach a sample file.
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Problem solved everything working perfectly.. I'd like to thank Richard for the first part of the code. The second part took some trial and error but I final got it working. So I'm posting the code in case someone else comes across the same problem.
Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Not Intersect(Target, Range("C2:C10")) Is Nothing Then Target.Cells(1, 2) = Target.Cells(1, 2) + Target End If Range("C2:C10").Select Selection.ClearContents Range("C2").Select Application.EnableEvents = True End Sub
OK, I was looking for the answer to this exact question. Problem is, I don't know how to use this answer as given. Is this a macro? How do I incorporate it?
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks