Need formula of VBA whereever find total in A:A

Dear experts

good to all

I have range of data copied from pivot i want apply some calculation with formula if its possible apply vba

i want calculate only Subtotal values where find string along with total like "US Total"

under month there is Week number like 1,3,7,10,12.

i want start with date 1-Feb-15 sum (1,3,7) and sum(10/24*14) and sum(12/36*14)
1-Mar-15 = sum (1,3,7) and sum(10/24*14) and sum(12/36*14)
1-Apr-15 = sum (1,3,7) and sum(10/24*14) and sum(12/36*14)
Last two row1-May-15 = sum (1,3,7) and sum(10/24*13) and sum(12/36*13)
Last row1-Jun-15 = sum (1,3,7) and sum(10/24*12) and sum(12/36*12)

Like date start with any date start for 10&12 for 10/24*14 & for 12/36*14 last two date segment i want 13&12

find the attachment brief explanation given

Any experst help on this?

Sir will u not see the pivot table In sheet Pivot_ In column T:T i want calculation with formula towards every subtotal of country. and find the explain sheet which brief my requirement if data get more in pivot

Any experts help on this????

any experts help on this urgent requirement!!