software

I want to use a formula in a cell (fixed) that contains a cell as reference
which in turn is subject to quot;movequot; by sorting.
Is this possible?


I don't fully understand your question, but you may want an absolute
reference (e.g. Change =A1 to be =$A$1 which means the formula never
changes when moved/copied), or don't sort the column containing the
formulas.
Clive--
Clivey_UK
------------------------------------------------------------------------
Clivey_UK's Profile: www.excelforum.com/member.php...oamp;userid=32569
View this thread: www.excelforum.com/showthread...hreadid=535872The column containing the formula in let´s say A1, HAS do be moved (sorted),
but the formula in cell Q8 should always refer to the value that was
formerly in cell A1 and might now be in A5. This row 1 is part of a table
that gets sorted. The line, that contains the value (in row 1) to be used in
cell Q8 contains some fixed text, that never changes. Might this help?
(Something similar as quot;COUNTIFquot;)

There are other

Thank you

Felix

quot;Clivey_UKquot; wrote:

gt;
gt; I don't fully understand your question, but you may want an absolute
gt; reference (e.g. Change =A1 to be =$A$1 which means the formula never
gt; changes when moved/copied), or don't sort the column containing the
gt; formulas.
gt; Clive
gt;
gt;
gt; --
gt; Clivey_UK
gt; ------------------------------------------------------------------------
gt; Clivey_UK's Profile: www.excelforum.com/member.php...oamp;userid=32569
gt; View this thread: www.excelforum.com/showthread...hreadid=535872
gt;
gt;

If you are just generating a table to be sorted for reports you could make
a copy of your worksheet to sheet2 then convert sheet2 to values,
do you sort on sheet2 and your report from sheet2. You would only
update sheet1 and report from sheet2 after preparing it from sheet1.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;fak119quot; gt; wrote in message ...
gt; The column containing the formula in let´s say A1, HAS do be moved (sorted),
gt; but the formula in cell Q8 should always refer to the value that was
gt; formerly in cell A1 and might now be in A5. This row 1 is part of a table
gt; that gets sorted. The line, that contains the value (in row 1) to be used in
gt; cell Q8 contains some fixed text, that never changes. Might this help?
gt; (Something similar as quot;COUNTIFquot;)
gt;
gt; There are other
gt;
gt; Thank you
gt;
gt; Felix
gt;
gt; quot;Clivey_UKquot; wrote:
gt;
gt; gt;
gt; gt; I don't fully understand your question, but you may want an absolute
gt; gt; reference (e.g. Change =A1 to be =$A$1 which means the formula never
gt; gt; changes when moved/copied), or don't sort the column containing the
gt; gt; formulas.
gt; gt; Clive
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Clivey_UK
gt; gt; ------------------------------------------------------------------------
gt; gt; Clivey_UK's Profile: www.excelforum.com/member.php...oamp;userid=32569
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=535872
gt; gt;
gt; gt;