I have two excel spreadsheets in 2003. I want to search the main spreadsheet
for certain ID code. Once that code is found to dump the associated
information that has 10 separate columns on one row from the second
spreadsheet into new columns in the main sheet.

Example:

Main sheet has 15 columns of personal information with a keycode. Let's says
the keycode I want is 129. In the other sheet I have name, address, province,
country, postal code and key codes. I want to take the customer info
associated with key code 129 and dump into the main sheet in all places that
has the key code 129.