| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Copyingfunctions from one worksheet to another
Is it possible to copy functions from one worksheet to another in the same
workbook and have them reference the cells (non-named cells) they formerly calculated? For example, sum(A1:A5) on Worksheet 1 is copied and moved to Worksheet 2, but still captures the sum of A1 to A5 on Worksheet 1, actively capturing any changes to the cells on Worksheet 1. Thanks for any advice! |
|
#2
|
|||
|
|||
|
Spyder,
Use cut and paste. If you need to actually have a copy, press F2, select the formula in the formula bar, press Ctrl-C, then Esc, then select another (blank) cell, press F2, and press Ctrl-V. Then Cut and paste that new cell. HTH, Bernie MS Excel MVP "Spyder" wrote in message ... Is it possible to copy functions from one worksheet to another in the same workbook and have them reference the cells (non-named cells) they formerly calculated? For example, sum(A1:A5) on Worksheet 1 is copied and moved to Worksheet 2, but still captures the sum of A1 to A5 on Worksheet 1, actively capturing any changes to the cells on Worksheet 1. Thanks for any advice! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
Hybrid Mode
