Forum Discussion
Ecxel VBA
Hi, i would like to filter a table (5000+ rows, 20+ columns) with multiple criteria. More specifically, i would like to give a unique id ( 6digit NUMBER from the first column) and return ALL the oth...
Hello,
Your project can actually best be done with Power Query.
For 2016 you would have to download it and paste it into Excel.
Here is an example in the file.
You can also use filters or do it with data slices.
With VBA it would be too cumbersome...in my humble opinion :).
Thank you for your patience and time.
Thanks for the reply, but unfortunately i haven't used Power Query before. So i can't understand what i'm supposed to do.