Re: Relative/absolute cell references

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thank you. That did the trick.

Jan

"Bob Phillips" <phillips@xxxxxxxxxxxxx> wrote in message
news:%23OQFvqIVFHA.3944@xxxxxxxxxxxxxxxxxxxxxxx
> Maybe
>
> =INDIRECT("A1")*INDIRECT("A3")
>
> --
> HTH
>
> Bob Phillips
>
> "Jan Kronsell" <span@xxxxxxxxx> wrote in message
> news:%23qsTwdIVFHA.3540@xxxxxxxxxxxxxxxxxxxxxxx
>> I have a formula, like for instance = A1*A3
>>
>> I like to copy this, relatively, that is updating it to =A2*A4 and so on.
>>
>> The data is supposed to be in A1, A3 or A2, A4, but if the user moves the
>> data from A1 to B1 the fomula is updated to =B1*A3.
>>
>> Is there someway I can prevent that? So no matter where the user moves
>> the
>> data, the formula will remain unchanged?
>>
>> Jan
>>
>>
>
>


.

Quantcast