Hi,

I am Getsuko Teng. I have a question.

Can I know, is there any way to build a macro that can auto recognize yellow highlighted column in the spreadsheet, and then auto delete the column in front of the yellow highlighted column?

After deleting, the macro is able to copy the whole spreadsheet and paste special to another workbook which is XML file?

Thanks in advance.


Regards,
Getsuko Teng