Hi there.

I was wondering, is there a way in MS Excel 2003 (or 2000) to autocomplete a row of fields based on the selection the user has made from a drop down box, or from what they have typed in another cell on the same row?

This data can be retrieved from perhaps another worksheet within the same spreadsheet

possible?