Hello,

I have imported an XML document (Sheet1) and want to search the text "Sql Query" (say column CW, row 300), and paste the adjacent cell (CX300) in Sheet2. I have tried to do so in two ways, using vlookup and recording a macro. In both of them, the column with contains the keyword "Sql Query" freezes and it makes it impossible to reuse the same for the next imported XML document as the XMLs do not have same structure, their grain differs but they do have "Sql Query". The second XML had "Sql Query" in CZ 340 and CZ 408. Could any one help me out with the same? The column with has "Sql Query" might move and if there are multiple instances of "Sql Query", they will fall under the same column and I need to copy the adjacent cells in another sheet, say column A.

Regards.