Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum of cells in new worksheet
Is there a shortcut key that will allow me to copy the sum of a range of
cells from a different worksheet? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding several worksheet cells onto a main worksheet | Excel Worksheet Functions | |||
CountIF() in Worksheet B while referencing cells in Worksheet A | Excel Worksheet Functions | |||
Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
linking cells in one worksheet to cells in another worksheet | Excel Worksheet Functions | |||
I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) |