Hi Allan

You could have a 2 pronged approach to this.

1. Name Sheet.1 as Data Input.

your 1st column could be converted to a Validated List and then
you can populate your other 2 columns using a lookup table.

example:

=IF(I6="","",(LOOKUP(I6,INFO!$H$2:$L$132,INFO!$I$2 :$I$132)))


2. Name sheet.2 as Data Export

After you have finished inputting the information, copy the range you
require, then PasteSpecial.Values into here and export this into your .CSV
File.

Check out Debra Dalgliesh's website for some really good examples of Data
Validations and lookups.

http://www.contextures.com/xlDataVal08.html

HTH
Mick