Alright, so not knowing any word/excel/vb programming. I pretty much wont be able to do it! My basic need is a form with 3 fields. The first filed I would like to simply select a number from the drop down list, and that number will correspond to an excel sheet. with that number selected, the form will then automatically insert data from the corresponding two cells next to it. for instance, drop down list will be A1. When # 3 in drop down list then field 1 and 2 will automatically have data from B3 insterted into field1 and C3 in Field2.

So I take it that is very complicated to do?