In your validation rule, change

=H47

to

=$H$47

The '$' tells it to lock to that row or column (so H$47 would allow it
to change to I47 if you copied into a cell to the right)


--
TommySzalapski
------------------------------------------------------------------------
TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561
View this thread: http://www.excelforum.com/showthread...hreadid=390361