Originally Posted by
Pete_UK
Assuming your data is always in the same layout on those monthly sheets (i.e. Dogs is always on row 2), then it would be a bit more flexible if you entered the date of the current month in D1 rather than rely on the TODAY() function, as you might not create the July sheet until, say, 3rd July. So, in your example put 1/06/2015 in D1, then you can have this formula in D2:
=INDIRECT("'"&TEXT(D$1,"mmmyy")&"'!B"&ROWS($1:2))-INDIRECT("'"&TEXT(D$1-1,"mmmyy")&"'!B"&ROWS($1:2))
which can be copied into D3. Then when you have created a sheet for July, just change the date in D1 to 1/07/2015 - this also makes it more obvious which months you are comparing.
Hope this helps.
Pete
Bookmarks