Tom,

The normal condition would be the user would have many rows of data and
a specific column would be blank and need to be filled in. Or later one
of the values would need to be changed. The user would select row on
that specific column and start the program. The program would populate
that cell and move the next row to repeat the function.

This is the same as what you suggested but just working from the
current cell rather than appending to the bottom.

Dan


--
dthames
------------------------------------------------------------------------
dthames's Profile: http://www.excelforum.com/member.php...o&userid=28793
View this thread: http://www.excelforum.com/showthread...hreadid=484821