| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy & Paste Forumla - but reference cell is changing
I am trying to copy and paste a large section of one worksheet into another
but the reference cell in the formula keeps changing. How can I paste it so that the reference cell remains the same regardless of where I paste it? i.e. Cell B15 in Sheet 1 has the formula =IF(model!AA25<"",model!AA25,model!Z25). When I paste this into cell C8 in Sheet 2, the formula changes to =IF(model!AB18<"",model!AB18,model!AA18) but I want it to still reference model!AA25¦ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy-paste started misbehaving (cell reference wrong) | Excel Discussion (Misc queries) | |||
| Using cell reference and wildcards in a forumla | Excel Discussion (Misc queries) | |||
| Reference an identical cell on a different page using copy/paste? | Excel Worksheet Functions | |||
| HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE | Excel Discussion (Misc queries) | |||
| Is there a forumla to link an absolute cell reference in multiple. | Excel Worksheet Functions | |||
Threaded Mode
