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
N53: 1000 €
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
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