Limited autoformatting when pasting

[Flaxkrax]

Trying to find a timesaving operation, help needed.

I.E. a formula like this;

IF(LEFT(SheetA.A1,1)="X",(SheetB.B1*SheetC.C1),T(""))

Now using this formula in Sheet D, I want the Table A value to remain fixed and the B&C values move along as I paste the original down rows or columns.
On row zz and colum YY it should look like this;
IF(LEFT(SheetA.A1,1)="X",(SheetB.YYzz*SheetC.YYzz),T(""))

Help!

//Johan

[Stefi]

Hi Flaxkrax,
Try this:
IF(LEFT(SheetA!$A$1,1)="X",(SheetB!$B1*SheetC!$C1),T(""))

Regards,
Stefi


„Flaxkrax” ezt �*rta:

>
> Trying to find a timesaving operation, help needed.
>
> I.E. a formula like this;
>
> IF(LEFT(SheetA.A1,1)="X",(SheetB.B1*SheetC.C1),T(""))
>
> Now using this formula in Sheet D, I want the Table A value to remain
> fixed and the B&C values move along as I copy it down rows or columns.
> On row zz it should look like this;
> IF(LEFT(SheetA.A1,1)="X",(SheetB.Bzz*SheetC.Czz),T(""))
>
> Help!
>
> //Johan
>
>
> --
> Flaxkrax
> ------------------------------------------------------------------------
> Flaxkrax's Profile: http://www.excelforum.com/member.php...o&userid=36040
> View this thread: http://www.excelforum.com/showthread...hreadid=558333
>
>

[Flaxkrax]

That was just what I was looking for!!


//Johan "Flaxkrax", greatful newbie

[Stefi]

Thanks for the feedback!
Stefi


„Flaxkrax” ezt �*rta:

>
> That was just what I was looking for!!
>
>
> //Johan "Flaxkrax", greatful newbie
>
>
> --
> Flaxkrax
> ------------------------------------------------------------------------
> Flaxkrax's Profile: http://www.excelforum.com/member.php...o&userid=36040
> View this thread: http://www.excelforum.com/showthread...hreadid=558333
>
>