You have shown me how to bring the summary cell from one WS to another either through the Watch Window or the use of:
But what I would like to know, can I write a formula into a cell on one WS to act on a range in another WS as in:
I played with this for a while but could not get it right..
Can this be done and for that matter can it be done cross Workbook as well.
Will the Indirect Function once again be the solution to the problem?