Seamus2626

asked on

# VBA Code

Hi,

Attached i have a file with a pivot that changes each day (Screen). In the tab "RC Check" i want to start a daily build up of the two amounts in E121+G121. So i would like a sub that can read those two headings and place them in the next cell down in A+B. I would also like to be able to place the formula in the C+D that would calculate the difference between today and yesterday, and also drop now() into the adjacent cell E

The aim is to see any differences betwee today and yesterday for those sub groups.

Once challenge however is that in the pivot table, E121+G121 are not static so the figures would need to be read by the Sub Total of Risk and Control, column 5+7.

Thanks!

Seamus

Example.zip

Attached i have a file with a pivot that changes each day (Screen). In the tab "RC Check" i want to start a daily build up of the two amounts in E121+G121. So i would like a sub that can read those two headings and place them in the next cell down in A+B. I would also like to be able to place the formula in the C+D that would calculate the difference between today and yesterday, and also drop now() into the adjacent cell E

The aim is to see any differences betwee today and yesterday for those sub groups.

Once challenge however is that in the pivot table, E121+G121 are not static so the figures would need to be read by the Sub Total of Risk and Control, column 5+7.

Thanks!

Seamus

Example.zip

ASKER

thanks Sid!

I just need

C2= A2-A1

D2= B2-B1

C3=A3-A2

D3=B3-B2

etc

Thanks!

I just need

C2= A2-A1

D2= B2-B1

C3=A3-A2

D3=B3-B2

etc

Thanks!

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Absolutely perfect Sid!!

Thank you so much

Seamus

Thank you so much

Seamus

For the rest see this sample File. The values will be updated every time you click on the update button.

Sid

Code UsedOpen in new window

Example.xls