| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copy formula
I want to copy a formula from one cell to another but need the sheet
reference to change from "sheet 1" to "sheet 2" in the formula: Example = SUMIFS('[WKLY YR06.xlsx]Wk1'!$C$2:$C$5000,'[WKLY YR06.xlsx] Wk1'!$E$2:$E$5000,"TF5",'[WKLY YR06.xlsx]Wk1'!$D$2:$D$5000,"600020") This formula is in cell C4, I want to copy to D4 and I want everything to stay the same but go to the next sheet (same place in the sheet). Can anyone help me??? Kim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
| copy formula result (text) only - without copying formula | Excel Discussion (Misc queries) | |||
| I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
![Kim[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
