Type in K2: =$M$2 and fill down until K51!
Regards,
Stefi
€žlaz€ť ezt Ă*rta:
whatever number I enter into cell M2 I would like for that number to
show down the whole column K.
Ex. in cell M2 I enter the number 100, I should then see 100 in column
K in the range of k2:k51.
How can I make this possible. Any help would surely be appreciated.
Thank you in advance. I know this may sound silly but its hurting my
brain. lol
Lazarus
in Ca.
--
laz
------------------------------------------------------------------------
laz's Profile: http://www.excelforum.com/member.php...fo&userid=2526
View this thread: http://www.excelforum.com/showthread...hreadid=483844