Hi,
laz

if u want to enter value M2=100 , which would appeared in cell K2:K51
u have to enter formula in cell K2 :K51 = $M$2

the purpose of using " $" before M is to Fix Index of Row whereas
putting "$" after M indicates that Column Index has been fixed.

hence by Putting "$M$2', Row as well as Column index has ben fixed
which gives value of cell M2 in copied cell.

;) ;) ;)


--
NITESH G
------------------------------------------------------------------------
NITESH G's Profile: http://www.excelforum.com/member.php...o&userid=17590
View this thread: http://www.excelforum.com/showthread...hreadid=483844