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.