sht2.range('Y2').expand('table').value = sht1.range('AK2').value
把sht1的ak2都复制到了sht2的Y2上
sht1.range('AK2').value=sht2.range('Y2').expand('table').value
把sht2的值复制到sht1
sht2.api.Columns('Y:BQ').Copy(sht1.api.Columns('AK:CC'))
把sht2的列复制到sht1去
wb2.sheets['summary report','detail report','Backlog','summary GIT'].api.Copy(After=wb1.sheets['Status'].api)
将多个wb2的sheet copy到wb1的status sheet后面