| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying formulas with relative references
When you paste the value there should be a little clipboard that shows up
next to the cell. Click on that and then click on the button that says link cells. "Carl" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying formulas with relative references
Thanks, that pulls the cell of the address that I want but drops the rest of
the formula. Is there a way to still keep that. For example, the value of A1 in Sheet1 is 10. I want the value of A1 in each sheet that I am using to be incremented by 1. Therefore the formula I am using in Sheet2 is =Sheet1!A1+1 and in Sheet3 the formula is =Sheet2!A1+1, etc. When I use the "link cells" option, the +1 part of the formula is dropped. "akphidelt" wrote: When you paste the value there should be a little clipboard that shows up next to the cell. Click on that and then click on the button that says link cells. "Carl" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
