How Do I specify where XML data gets imported into Excel

D

Diane

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XML data import breaks cell formatting 0
XML to Excel 0
Export as XML for an Excel Order form document 1
Transpose 1
Return latest value from data range 4
How to import data from Sheet1 to Sheet2 in the order I want 3
How do I get 00 or 01 from XML to Excel it displays as 0 or 1? 1
How can I move data from a row range to a column range 4

Top