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