Hi,
I have a sheet containing list of names at say "A1" to "A300"
in another sheet i have to enter information like payments etc to any of these names. format of the data entry sheet is as below:

Names Date Amt.Paid etc

My problem is when I make an entry, i should get list of names in column A and I should be able to select a name form the list. This would validate the names.

Can somebody suggest a way to do this.
Thank you.