# Need formula of VBA whereever find total in A:A

1. ## 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  Register To Reply

2. ## Re: Need formula of VBA whereever find total in A:A

Any experst help on this?  Register To Reply

3. ## Re: Need formula of VBA whereever find total in A:A

I have range of data copied from pivot i want apply some calculation with formula if its possible apply vba
where do we find the pivot, what actions need to be done.

So more general, the question is not clear, at leat not to me.

Show it in a small excel file, and mark related cells with the same color.  Register To Reply

4. ## Re: Need formula of VBA whereever find total in A:A

I just want calculation after grand total in pivot. find the attachment sheet Pivot_ @ column T:T is my requirement.

my main requirment is if extra data added in pivot how does formula or vba get works.  Register To Reply

5. ## Re: Need formula of VBA whereever find total in A:A

Ther is no sheet Pivot_ @ in your file !!!

Edit

Show it in a small excel file, and mark related cells with the same color.
I don't see the color of the related cells either.  Register To Reply

6. ## Re: Need formula of VBA whereever find total in A:A

@oeldere, I think the @ relates to column T:T i.e. "@ column T:T", there is a sheet called "PIVOT_" which has a pivot table   Register To Reply

7. ## Re: Need formula of VBA whereever find total in A:A

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  Register To Reply

8. ## Re: Need formula of VBA whereever find total in A:A

Any experts help on this????    Register To Reply

9. ## Re: Need formula of VBA whereever find total in A:A

any experts help on this urgent requirement!!  Register To Reply

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