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
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.
You must log in to post.
Thank you so much for visiting us & taking first step to become awesome in Excel. Please use below links to navigate our site.
Subscribe
