I have a formula I want to copy down columns, but I want to keep half o
it to remain the same, is there some way to lock some of it?

This is the formula: '=SUM(E4*Sheet2!A2)' the next row needs to be
=SUM(E5*Sheet2!A2), then
=SUM(E6*Sheet2!A2).

As it shows the -Sheet2!A2- needs to remain the same.

I use the drag method to copy the formula, but it increases both part
resulting in:
=SUM(E4*Sheet2!A2), then
=SUM(E5*Sheet2!A3), then
=SUM(E6*Sheet2!A4).

Can anyone help me, as going down what will become more than 100 row
changing the second half back to A2 is extremely tedious and annoying

--
densityflu
-----------------------------------------------------------------------
densityflux's Profile: http://www.excelforum.com/member.php...fo&userid=2357
View this thread: http://www.excelforum.com/showthread.php?threadid=38764