Sheet1 is possible with 10 columns and filter columns 3 and paste in Sheet2?

Goodnight everyone,

My question is: have a database with 10 columns (A to J), the tab Sheet1, for example. I want to create, Sheet2 tab an ADVANCED FILTER, with certain criteria in there own Sheet2 tab, which would run via Macro. So far so good.
But want me to return the advanced filter only some columns of the interleaved data, for example, column A, D and I specifically, not the entire range of A to J, because the data in columns that will exclude not Me interest for this query.

Thank's

Hi marreco
The simplest approach would be to create the advanced filter to Sheet2 then, as part of the macro, hide (or delete) the Sheet2 columns you wish not to see.

Hi marreco
Column E of Sheet BD has an empty cell...will this be the case in your real file?

Yes, I can see that...Cell E2 is empty...my question is this

will this be the case in your real file?

Hi marreco
We're not communicating. In your real file, will there be empty cells in Sheet BD, Column E or will Column E ALWAYS have data? Yes or No?

Thank you Sir...that makes things easier...perhaps

Hi marreco
Try the attached. The code does as follows:
On Workbook Open, creates a new Worksheet called Temp and creates a Named Range called Devedor of the Unique Values in Column E of BD. This Named Range is then used as a Data Validation Dropdown List for Cell A2 of CONSULTA. Select an Item from this Dropdown List to execute the procedure.
This Code is in EstaPasta_de_trabalho Module

Please Login or Register  to view this content.

And this Code is in CONSULTA Module

Please Login or Register  to view this content.

Hi marreco
You're welcome...glad I could help.