If I understood you correctly (If your subtotal for A is per say in
Sheet 1,A5 and you want it in sheet 2, d1).

You could put something like this in Sheet 2, D1.

=sheet1!a5

Change the sheet name to the name of the sheet you are referencing

If it's in another workbook you'll need to change the file path to
reflect it

Larry


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=499188