Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating XML
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating XML
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating XML
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating XML
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. "Please Help" wrote: 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating XML
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. "Janis" wrote: 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. "Please Help" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating VBA Functions When Creating Spreadsheet Via VBA? | Excel Programming | |||
Creating and using add-ins | Excel Programming | |||
creating a pdf | Excel Discussion (Misc queries) | |||
creating PNG | Excel Programming | |||
Creating an XLL with C# | Excel Programming |