Results 1 to 3 of 3

Modify macro for running totals

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-30-2011
    Location
    wirral,england
    MS-Off Ver
    Excel 2010
    Posts
    148

    Modify macro for running totals

    Hello All
    On the attached worksheet,col C has a list of names in chronilogical order,cols G,M,V,W contain related data
    Cols AO,AP,AQ keeps a running total of prize won ,best par & best speed to date one row down from the data collected from cols M,V,W.
    For example on 18/5/10 AB Celebration from date previous to 18/5/01 is 7000,He won again on 3/6/10 so his
    total prize money won coming into his next race on 4/6/10 is 9500,his best par to date on 18/5/10 is 30 achieved on 6/5/10,the 18&80 figs at AP2&AQ2 are from existing data prior to 6/5/10.
    I hope this will become clearer from sheet 2 on the attached worksheet,I have left an empty row between names for clarity,there are no empty rows in the data.The macro i have (on sheet 1)will only calculate prize money won from col M & omits the existing data in col AO,it also omits the existing data in col AP&AQ row 2.
    Is it possible to modify this macro to maintain and add to existing data in col AO,so i have data as in sheet 2.Many thanks for help given.
    Attached Files Attached Files

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