Advanced Filter: How to select output columns and rename the output columns

[sachdev_dj]

Hi,


I need to filter data based on a criteria but the output


a) should have only selected columns (extract range).


b) the output column names to be of my own choice (not same as column names of the input data)


c) reformat the output columns - example, i need to design the output such that some of the columns will be moved as row values


Can this be done using Advanced filter (how) or i need to apply some other mechanism.


Thanks

 

[Luke M]

You can't do all of that using just Advanced Filter. My recommendation would be to record a short macro of yourself doing the Advanced Filter, changing column names, removing unwanted columns, and then re-formatting.

This would give you a base code that you could then probably tweak as needed to make more versatile.