Hi,
In the attached sheet, I want the exact output available in sheet "Myoutput" to be copied from sheet1.
In sheet1, the data are not aligned for particular column. Therefore the macro should be designed such that wherever it finds the column(e.g. to find country from column named as /team/manager/user/userid/countryid/countryname), it should populate the same text value in "Myoutput" sheet.
I am not able to find solution how to proceed if data are present in zig zag manner in diff column.
Bookmarks