Dear VBA Exports,
I need your guidance to build a vba sript to loop through few data.
I can loop with in a range where all the row and column has data.
But when there are few column of the row doesnot have data i am not able to build a loop sript.
For example
I have a range from A6 to W14. and range can be dynamic.
Range A6 to D14 has data only on Row 6, 10 & 14. and Range E6 to W14 has data in all cells.
I am looking for a loop to get result in the below format (Seperate line for each cell data"
Basically I am looking for it to loop from A6 to I14 then E7 to W7 then E8 to W8 then E9 to W9 then A10 to W10, E11 to W11 then E12 to W12 then E13 to W13 then A14 to W14.
Sample file attached for your reference.
Below is the result what i am looking to get through the loop.
Please help
Expected Result in xml or txt file with each line separately.
I have to add some addtional xml code before and after each cell value.
The expected result sheet is just for reference. I don't need it in another sheet. I need the looping data to be saved as xml file. and I have to add different xml lines such as say "<Date>"& cells(#,#).value &"</Date>" like this to each looped value.
You may presume the Row 5 heading as xml start and end code. Please guide me with the vba code.
If you can help me with dynamic row it will be great as i can use the cells(r,c).value with the xml codes.
Here r dim as row and c dim as column.
so my code can go as "<Date>" & cells(r,c).value & "</Date>".
Please provide me a working code. Thanks in advance.