Modify macro for running totals

[bigband1]

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.

[venkat1926]

you have not made it clear what sheet you are talking about and
what column or what cell
where did 7000 come from

what is relatisonship between column M in sheet 1 or sheet 2 and
column AO in sheet 2.

what is ther relation ship betwen sheet1 and sheet2
why sheet 2 atall

some claifictions may be necessary giving examples and referring to
sheet name and cell address

[bigband1]

Thanks for the reply.I have attached another spreadsheet which will hopefully explain it better,cols A to W,rows 2 to 6 represents existing given data which i wish to add to.Cols AO & AQ are keeping running totals of prize won,and max par & speed achieved to date.

When i add new data at 5/6/12 and run the macro i lose existing data.I have added cols AR to AT rows 2 to 6 to show what im trying to achieve.Thanks again.