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
Bookmarks