Creating XML

[Guest]

Good morning,

I have a workbook with 10 worksheets. I want to create a worksheet 11 for
XML on the data from 10 worksheets.

Can someone share with me on creating one?

Thanks.

 

[Guest]

IT isn't clear to me what you want to do? Do you want the totals on sheet
11? I think you must want to automate something but if you save the 11th
sheet as an XML file you will have XML. If you want to automate the saving
process you can use vba. You have to explain the steps of what you want to
do manually then it can be converted to vba.

 

[Guest]

Hi Janis,

Thanks for your response. Basically, I have information on students (name,
address, etc.) in 10 worksheets. I want to create an XML list on student
information in Worksheet 11 from 10 worksheets.

I don't know what to do to have the student information from 10 worksheets
got into Worksheet 11 (XML). Then I have to take the XML (Worksheet 11) and
send it to the state for reporting.

Do I link Worksheet 11 to each piece of data in 10 worksheets?

Thanks.

 

[Guest]

IF it is something like a database, you want, the student information on the
11th sheet you can try using vlookups. It is rather difficult to explain but
once you get it it is a nice way of getting data from another sheet.
You could put all the students names on the 11th sheet and do a vlookups to
pull in the data you want. You should read the vlookup function and try to
figure it out then post back with questions. I'm not sure what data you want
to pull in.

 

[Guest]

Unfortunately, the vlookup would not work for me because we don't really know
who the students are. Basically, for XML (Worksheet 11), we need: Student
ID, Student Last Name, Student First Name and Student Grade.

Generally, if you want to create an XML for the data from 10 worksheets,
what steps you would take to create one?

Thanks.