sum of cells in new worksheet

S

Sharon

Is there a shortcut key that will allow me to copy the sum of a range of
cells from a different worksheet?
 
G

Gary''s Student

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
 
Top