If the order form is hard copy, type in the information.

If in a file, let Excel pull in the file. The Help files will tell you how
to bring in a file that is not in .XLS format.

If in a database, you will have to let Excel query the database. The Help
files will tell you how to do that (sort of).

That is the best I can do without a good bit more detail regarding the exact
nature of your challenges.

I hope this helps.

--- BBQDad

--
"A little learning is a dangerous thing..." ----- A. Pope