Copy and paste in one worksheet by condition

[behrooz_chz]

Hi
In one worksheet i have a table with 3 column ABC column A is text that fill manualy B is number fill with vlookup and C is percentage of column B so beacuse of some row column B is zero i need to export a new table in column E to G that only show the row of previous table that column B is greater than zero to define a series by offset and count to draw a pie chart
So i need a VBA to copy and paste rows that have value in column B greater than zero in column E To G
sample has been attached

[sintek]

Please Login or Register  to view this content.

EDIT
If you don't want Total row...

Please Login or Register  to view this content.

[behrooz_chz]

second VBA work with 2 problem
1- when add new row i need to run VBA to apply
2-every time i run it previous exist row will be copy again in column E to G is it possible to paste new row only ?

[sintek]

So i need a VBA to copy and paste rows that have value in column B greater than zero in column E To G

This was your first request...Code was written for this...

I suggest you explain in more detail what your requirement is...

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)