At 10:25 05/11/2008 -0500, Bill Drescher wrote:
A related, but different issue.
Col A is a calculated column. I want to copy the *value* of that to
Col B so that when I delete Col A I do not get an error.
How ?
Actually, I'm not sure what the problem is here. If you copy column
A to column B, you will get a new calculated column B. Provided you
have constructed the formulae in column A correctly - with the
appropriate use of $ signs - this should depend on the original
sources for column A and not on column A itself (unless the values in
some cells in column A depend on other cells in column A), so should
not be affected if you delete column A. If this does not do what you
want, you may need just to refine your formulae in column A, creating
different formulae that produce the same results in A but than
transfer properly to B.
But if you want to freeze the values in column B, so they are copy of
what was in column A but no longer depend on any source values, you
can use a similar technique to the previous one:
o Copy column A (or the relevant range of cells there).
o Paste into column B using Edit | Paste Special... (or right-click
| Paste Special... or Ctrl+Shift+V) instead of ordinary Paste.
o In the Paste Special dialogue, remove the tick from "Paste all" if
necessary and then ensure that Formulas is *not* ticked (and other
appropriate options are).
Unless you mean something different ...
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
