sum of cells in new worksheet

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

Is there a shortcut key that will allow me to copy the sum of a range of
cells from a different 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Sum across WORKSHEET 6
sum accross worksheets using names 1
How can I copy the sum of a filtered column into a cell in anothe 1
Totalling sequential worksheets 1
sum on multiple worksheets 0
Random #VALUE! error in simple SUM formula results 3
Sum Multiple Worksheets, same named cell 1
summing same cell in multiple worksheets 3

Back
Top