I have XML data that I would like to import up as fllows in a spreasheet:

Cell A2: Job Number
Cell A3: Customer Number

A4 through A29 should recive the <AMOUNT data
B4 through B29 should receive the <QUANTITY data

etc etc

Sometimes all the fields will be filled, sometimes not. Any help would be
greatly appreciated.

Regards,
Diane