This is a recurring report and needs to be flexible enough to allow dept.
managers to look at only thier data. The formatting etc. gets lost once you
start selecting my location.

"steven1001" wrote:


is there some reason that you can't do the calculation on the worksheet
instead of as a calculated field?


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