使用loop vba excel复制和粘贴数据

嘿团队，

我的数据包含从A到Z的列



列A到D是固定的，我需要的是我想要过滤E列，除了0值并将可见单元格从A复制到E并粘贴到摘要工作表中。 />


然后转到F列，除了0值，将可见单元格从A复制到D和F列数据，粘贴到最后的lastrow摘要表

I have data with contains from A to Z columns

Columns A to D is fixed, what i need i wanted to filter E Column except 0 value and copy the visible cells from A to E and paste into summary worksheet.

Then go to F Column except 0 value, copy the visible cells from A to D and F Column data only, paste into last lastrow summary sheet

然后转到G列，除了0值，将可见单元格从A复制到D和G列数据，粘贴到最后的lastrow摘要表中

Then go to G Column except 0 value, copy the visible cells from A to D and G Column data only, paste into last lastrow summary sheet

然后下一个循环... ...

Then next loop......

请推荐vba代码，因为我认为它应该循环使用。

please suggest the vba code as i assumed it should be used loop.