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