Hi All,

I need a macro to read the data in sheet 1 and pick the specific data in that and have to paste in in sheet 2.

Attached the sample spreadsheet.

Macro should read the A1 cell in sheet 1 and find the data between <item_id> and </item_id> and paste the data in B1 in sheet 2.
A1 cell in sheet 1 may have many item_id's, if it has more than 1 item_id then the macro to paste the next item_id in cell B2 in sheet2.

likewise i need the macro to find the another data called day and it will be pasted in next column (C1).


Please check the attached file for more clarity.

Sample.xlsx