Every month I have to complete a spreadsheet called Trends. I pull data by linking to a spreadsheet called Share and subtracting year to date data from year to date for the previous month.
For example in May on Trends, I enter a link share\ytd May\$D$27 - share\ytd April\$D$27.
And then in...
Maybe I am going about this in the wrong way.
I get year to date data coming off a specialized software program here and I have to calculate the month's activity and put it into a couple of Pivots.
Can I subtract one pivot from another? Say do a pivot with April Data and subtract it from YTD...