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.

"Janis" wrote:

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.

"Please Help" wrote:

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.