| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Linking with Absolute Reference
Hello - Did you find an alternative solution ?
"MikeDH" wrote: Sedgwick, I had thought about that for a while, but it would unfortunately be too much work. The sheet in question is a weekly delivery sheet for multiple farmer-producers, often - especially lately - with 300+ rows to reference. It just wouldn't be effective for me to name each row every time I enter something and still hope to get the other tasks done. I suppose I'll just have to copy-past normally every time I update something. -MikeDH "Sedgwick" wrote: Mike, if I understand your problem correctly, you should be able to work around this by using a defined name rather than a cell reference. To create a Defined Name you select the cells, columns or rows that you wish to read from, Click Insert = Name = Define. Choose a name that you can associate to the selected cells and click Add .. This was when you copy/paste your formula it will be looking at the NAME rather than a cell value. ie. =SUM((50*"Price_per_Beer")/"mates") If this doesn't explain it clearly, let me know and I'll try again =) Hope this was of help. "MikeDH" wrote: Just a general question: Is there any way to either: 1) Paste-special - Paste Link so the cells are then filled with absolute references ($x$#) instead of standard reference format (x#) or 2) Apply absolute reference format to all cell-references in a selected array? Essentially, I need to be able to paste-link in a way that the information referenced is the same even if something should be inserted above it in the referenced sheet. Any ideas or solutions would be greatly appreciated. -MikeDH |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| changing from relative to absolute cell reference in multiple form | Excel Worksheet Functions | |||
| how to paste formula but reference a fixed cell | Excel Discussion (Misc queries) | |||
| pivot table : formula to absolute reference a subtotal | Excel Discussion (Misc queries) | |||
| Absolute Reference | Excel Worksheet Functions | |||
Threaded Mode
