I'm looking for something like this. If M1.value = 1 then I need A3.
value = M6.value

Please help. I need this automated so whenever anyone enters a 1 in
cell M1 to dump the value of M6 into A3 automatically


--
mikespeck
------------------------------------------------------------------------
mikespeck's Profile: http://www.excelforum.com/member.php...o&userid=34946
View this thread: http://www.excelforum.com/showthread...hreadid=568660