is this way possible copy data from sheet to another with ignore the other based on value?

[abdo meghari]

hello
in my file I have macro bring data for specific customer but what I want copy from sheet account to sheet result based on cell value should ignore any cell in column e contain 0 doesn't copy data which before it ,it should copy after cell contain 0 I put the result in sheet expected result and I want copy to the bottom every time I select the the customer

[nankw83]

abdo meghari, can you post a sample file & show us what you have (before macro) & what you expect after the macro

[abdo meghari]

sorry I uploaded the file you can check it

[nankw83]

Try below code in sheet "account" ... This is one way to do it ... However, you have to change the "account2" header found in column "F" to something else that is not repeated twice in both sheets ..

Please Login or Register  to view this content.

[abdo meghari]

I no know how your code works but should copy all of data with all formatting and values from sheet account I don't write any thing in sheet result the code should do that it just copy the headers in row 6?

[nankw83]

No, the code doesn't copy the header only but as I said, you need to have different header names, I have changed the first "account2" to "account1" as per the attached file

[abdo meghari]

this is not what i want you misunderstood me what i want not ignore what cells contain 0 , I want also the values which precede cell which contains 0 it contains many values see the sheet account what highlighted by yellow color it shouldn't copy to sheet result

[abdo meghari]

any way to do that, guys?

[abdo meghari]

is it impossible to do that ?