advanced filter

[jmaocubo]

Hi

Anyone have experience with advance filters?


I have a table range M53: Q99
In this table values are imported from another sheet through VBA code

Later on the same sheet have another table with the range A53: I72


When the data is imported has a description in column M, a value in column N, another value in column Q and other in column Q

Eg:

M53: Demolitions
N53: 1000 €
P53: 10
Q53: 2



It turns out that there column N have the value zero because there is no value available from the other sheet.

What was meant was based on the column N filter to exclude the data with zero and copy the data for table 2
as follows:

M53 goes to the A53
N53 passes for F53
O53 passes to the D53





Is there an easier and fast way do this? I appreciate your views.


Thanks in advance

[romperstomper]

you'll get better help if you post a workbook rather than a picture, I suspect.

[jmaocubo]

you'll get better help if you post a workbook rather than a picture, I suspect.

Thanks for the quick intervention!
sending file example

[jmaocubo]

Thanks for the quick intervention!
sending file example

It could do with a loop (if statement)?

how?

[jmaocubo]

anyone????

[jmaocubo]

I apologize for being to insist .... but does anyone could help me?

[trucker10]

advance filters , see file example ( not yours )