| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying formulas with relative references
I want to copy a formula to multiple worksheets with part of the formula
referencing the value of a cell in the previous worksheet without having to manually change the worksheet name in the formula each time I paste it. Is there a way that excel will automatically reference the cell in the previous sheet as it does when copying and pasting within the same worksheet. Thanks for any insight anyone could provide. Cheers! Carl |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formulas, relative and absolute cell references | Excel Discussion (Misc queries) | |||
| Named formulas in CHOOSE need to be Relative references when paste | Excel Worksheet Functions | |||
| Confused about relative references in named formulas | Excel Worksheet Functions | |||
| copying formulas with different references | Excel Discussion (Misc queries) | |||
| Copying formulas (relative) give always original value | Excel Worksheet Functions | |||
Threaded Mode
