如何将excel 2007中突出显示的单元格从同一个工作表中的一个表复制到另一个表？

I wanted to copy the highlighted cells from one table to another in the same sheet, but the code that I use always skip the cell before the last cell, How can I edit the code in order to copy all the highlighted cells, and when I run the macro again it just update the second table ?I wanted to copy the highlighted cells from one