filter specific columns...

[sadams1]

I have several columns of data & would like to display only a few. I can manually hide them but it's a pain. I use the advanced filter & do the "copy to" another location thinking only the specific columns being put into the "critieria range" would be displayed but all columns come back. Is there a way to do something like this? I've gone through posts here & looking online & haven't anything like a macro or something to do this. Thanks!

 

[sandy666]

you can try PowerQuery
- load whole table into PQ Editor
- New Query:

[SIZE=1]let
    Source = Table.ColumnNames(Table1),
    #"Kept Range of Items" = List.Range(Source,3,3)
in
    #"Kept Range of Items"[/SIZE]

next New Query:

[SIZE=1]let
    Source = Table.SelectColumns(Table1,ColsToKeep)
in
    Source[/SIZE]

then you'll get 3 columns, starting from third column => 3,3

or
in PQ Editor select columns you want to keep then remove other columns and result load into the sheet

 

[ThisUserNaymIsTaken]

I just happened to make an Add-In for this kind of situation!
Here's a screenshot: https://imgur.com/a/Kd6EFGP
I don't really know what's the best way to share this with you, perhaps the other forum members can give a hint how I might share it.

 

[ThisUserNaymIsTaken]

adams1, If you want I'll simply post all the vba source code of the above mentioned add-in. I can do that tomorrow. Then you can copy paste it in your sheet and see if it works.