Results 1 to 8 of 8

Running total in a range of cells

Threaded View

heitres Running total in a range of... 05-03-2013, 09:35 AM
HaHoBe Re: Running total in a range... 05-03-2013, 10:13 AM
heitres Re: Running total in a range... 05-03-2013, 10:22 AM
heitres Re: Running total in a range... 05-03-2013, 10:30 AM
heitres Re: Running total in a range... 05-03-2013, 10:39 AM
HaHoBe Re: Running total in a range... 05-03-2013, 10:51 AM
heitres Re: Running total in a range... 05-03-2013, 03:15 PM
HaHoBe Re: Running total in a range... 05-04-2013, 01:29 AM
  1. #1
    Registered User
    Join Date
    04-29-2013
    Location
    Buenos Aires
    MS-Off Ver
    Excel 2007
    Posts
    5

    Running total in a range of cells

    Private Sub Worksheet_Change(ByVal Target As Range)
      If Target.Address = "$F$7" Then Range("G7") = Range("G7") + Target.Value
    End Sub

    I Found this formula in another thread. and I was wondering if its possible for this to affect a range of cells that I want.

    for instance I need it to go from F7:F20 / G7:G20, and also add exceptions( that the formula doesn't affect that one) to the ones that have the titles. for example F14.

    Thank you for your time!
    Last edited by arlu1201; 05-03-2013 at 09:56 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1