sum of cells in new worksheet
Insert the following macro and assign a shortcut key to it (say CNTRL-e ):
Sub sumit()
Range("Z100").Value = Application.WorksheetFunction.Sum(Selection)
Range("Z100").Copy
End Sub
The macro uses Z100 as a "helper" cell, modify to suit your needs.
Then:
1. select an area
2. touch CNTRL-e
3. click on your destination cell (in any worksheet)
4. touch CNTRL-v
--
Gary''s Student - gsnu200790
"Sharon" wrote:
Is there a shortcut key that will allow me to copy the sum of a range of
cells from a different worksheet?
|