Limited autoformatting when pasting
 

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

Limited autoformatting when pasting
 

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

Limited autoformatting when pasting
 

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

Limited autoformatting when pasting
 

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