Hi All,

I am new to VB in Excel and have a need to produce a Ready Reckoner that calculates pay.

I have a sheet with names, contract types etc

I have designed the form and what I want to do is have a drop down for the name that then fills in the rest of the information from that row on to the form I created. So when you select someone's name, it will fill in their contract type, etc from the row for that person.

Any pointers?:)

The earth has music for those who listen!

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

hi, mate '
you follow the what the article exactly said, you will get what you want,
cheers,