I tried to change sht = Array("E") to sht = Array("E", "K") in order to check both Columns and add it where the code paste the values, but no luck.
I need to keep the table.
What can I do?
Thank you in advance,
PS: Partial question have been posted here https://www.excelforum.com/exc…-problem.html#post5658628 and https://www.mrexcel.com/board/…-but-keep-format.1201684/