I'm trying to create a database on sheet 2, say from 1-40 names. i would
like to type in a numeric number (lets say #8) into sheet 1 say G, 4: I
would like the name from sheet 2 posted from say #8 to be posted into cell G5?

How do i do this?

Also, is it possible to have the pop up window prompt me for the next data
entry?

thanks