'The info source is actually two sheets as well, just to make this
worse'.
<<< a link in this page tells how to use a union statement to create a
view that contains the data from both sheets.
http://www.contextures.com/xlPivot08.html

'I've looked at pivot tables but they just seem to provide totals.
Perhaps I could create a table that takes one month's worth of data
from both sheets into a monthly total, completing all calculations at
once?'
<<<< if you double-click on any pivot-table value, a new worksheet will
be created that displays all records in that total. Would that provide
a solution?


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=548814