Copy - Paste Special

[DejaVu]

I've got a workbook with several sheets. On sheet 2, I have several columns with the following formulas:
=Sheet1!C$674
=Sheet1!C$684
=Sheet1!C$694 ... etc

I'm wanting to copy these to another location. They are in Column D (sheet2) currently, and I'm wanting to copy them to another location on sheet2; Column C.

However whenever I copy them, the formulas change to:
=Sheet1!B$674
=Sheet1!B$684
=Sheet1!B$694 ... etc

Is there anyway to get them to stay the same?!?

Thanks in advance...

DejaVu

[Don Guillett]

have you tried
$c$674

--
Don Guillett
SalesAid Software
[email protected]
"DejaVu" <[email protected]> wrote in
message news:[email protected]...
>
> I've got a workbook with several sheets. On sheet 2, I have several
> columns with the following formulas:
> =Sheet1!C$674
> =Sheet1!C$684
> =Sheet1!C$694 ... etc
>
> I'm wanting to copy these to another location. They are in Column D
> (sheet2) currently, and I'm wanting to copy them to another location on
> sheet2; Column C.
>
> However whenever I copy them, the formulas change to:
> =Sheet1!B$674
> =Sheet1!B$684
> =Sheet1!B$694 ... etc
>
> Is there anyway to get them to stay the same?!?
>
> Thanks in advance...
>
> DejaVu
>
>
> --
> DejaVu
> ------------------------------------------------------------------------
> DejaVu's Profile:
http://www.excelforum.com/member.php...o&userid=22629
> View this thread: http://www.excelforum.com/showthread...hreadid=379409
>

[PegL]

You need a "$" in front of the C to keep for formula the same.

"DejaVu" wrote:

>
> I've got a workbook with several sheets. On sheet 2, I have several
> columns with the following formulas:
> =Sheet1!C$674
> =Sheet1!C$684
> =Sheet1!C$694 ... etc
>
> I'm wanting to copy these to another location. They are in Column D
> (sheet2) currently, and I'm wanting to copy them to another location on
> sheet2; Column C.
>
> However whenever I copy them, the formulas change to:
> =Sheet1!B$674
> =Sheet1!B$684
> =Sheet1!B$694 ... etc
>
> Is there anyway to get them to stay the same?!?
>
> Thanks in advance...
>
> DejaVu
>
>
> --
> DejaVu
> ------------------------------------------------------------------------
> DejaVu's Profile: http://www.excelforum.com/member.php...o&userid=22629
> View this thread: http://www.excelforum.com/showthread...hreadid=379409
>
>