I hope this makes sense.

I am trying to reduce some manual intervention when creating an XM
file from Excel. Unfortunately I cannot just save the file in XM
format because many of the values are child values.

Current I copy a formula to a range of cells in a particular column
say column L, starting at row 5 and going to row n. The formula look
at values in other columns in the matching row concatenates the
together along with some hardcoded XML tags to create an XML string.

Example Data

Cell R5 = "Base Price"
Cell S5 = "" (Empty String)
Cell T5 = "22.50"
Cell U5 = "Online Price"
Cell V5 = "" (Empty String)
Cell W5 = "23.50"

I copy a formula to Cell L5 and the resulting value for L5 is:

<itemPriceLine
<itemPriceTypeRef
<nameBase Price</name
</itemPriceTypeRef
<itemPrice22.50</itemPrice
</itemPriceLine
<itemPriceLine
<itemPriceTypeRef
<nameOnline Price</name
</itemPriceTypeRef
<itemPrice23.50</itemPrice
</itemPriceLine

Any help wold be appreciate

--
mjm91
-----------------------------------------------------------------------
mjm917's Profile: http://www.excelforum.com/member.php...fo&userid=1471
View this thread: http://www.excelforum.com/showthread.php?threadid=26335