updatin totals in exc el via inputlist

**CoenRijn** · 07-11-2015, 02:06 PM

My problem is this:

I have a list of items i column A. In the next column there is the quantity of each item.
The probl;em is to updat the quantities. FRor eample:

A B C
1 item quantity update
2 brickA 10 5

I know that it is very simple to add the 5 new items to the total (10)
Then the new quantity is 15
After that calculation, I want to clean the quantity in column C to make it ready for a new input
But when I clean cel C2, the total changes back to 10... I want the 15 remains there, but how?

Can I do this by norma formulas or is VBA the only solution
I'm completely new to VBA

Thanks in advanve

Coen

**gmr4evr1** · 07-11-2015, 03:05 PM

Coen,
Place this code in the sheet you are using ....

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
      With Target
         If .Address(False, False) = "C2" Then
            If IsNumeric(.Value) Then
               Application.EnableEvents = False
               Range("B2").Value = Range("B2").Value + .Value
               Application.EnableEvents = True
            End If
         End If
      End With
    End Sub

See if that works for you

**CoenRijn** · 07-12-2015, 05:00 AM

Tom

Thank you. it's working fineBeste regards

Coen

**gmr4evr1** · 07-12-2015, 08:12 AM

You're welcome Coen, glad it worked for you.

Please mark the thread as "SOLVED" using the thread tools option in your original post, thank you

updatin totals in exc el via inputlist

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

updatin totals in exc el via inputlist

Re: updatin totals in exc el via inputlist

Re: updatin totals in exc el via inputlist

Re: updatin totals in exc el via inputlist

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to get cumulative totals from weekly totals (IE sum of all previous cells)?

[SOLVED] running totals in Pivot Table - removing a user from the totals for the current week

[SOLVED] How do I group daily totals into weekly/monthly/quarterly totals

Method for calculating Invoice Totals and Grand totals

Calculating grand-totals using numerous sub-totals in seperate coloumns.

Bookmarks

Bookmarks

Posting Permissions