lfalla
09-13-2016, 01:36 PM
First of all, sorry if this is super basic. I swear that I've searched extensively about how to solve this problem but I couldn't find any answer. Also, since my VBA skills are nearly zero, I'm not able to solve it by myself.
I have a spreadsheet with several sheets. Number one sheet is some sort of index. The thing is: I would love to create buttons (in sheet #1) that could make possible to (1) filter/sort the information in another sheet (for example, sheet #2) and then (2) show sheet #2, with the filtered/sorted information.
There is no need to copy, no need to delete, anything, just a button that if pressed tossed me to the specific sheet with a specific information showing first and or filtered.
I am able to make "hyperlink" buttons (with VBA, yay), but I can't find any way to add the prior part of filtering/sorting. Everytime I tried to add another code that I found to filter or sort the code would crash and once again I would get stucked.
If anyone happen to have any insight or reference text for me I would greatly appreciate.
Thanks a lot and sorry my english.
I have a spreadsheet with several sheets. Number one sheet is some sort of index. The thing is: I would love to create buttons (in sheet #1) that could make possible to (1) filter/sort the information in another sheet (for example, sheet #2) and then (2) show sheet #2, with the filtered/sorted information.
There is no need to copy, no need to delete, anything, just a button that if pressed tossed me to the specific sheet with a specific information showing first and or filtered.
I am able to make "hyperlink" buttons (with VBA, yay), but I can't find any way to add the prior part of filtering/sorting. Everytime I tried to add another code that I found to filter or sort the code would crash and once again I would get stucked.
If anyone happen to have any insight or reference text for me I would greatly appreciate.
Thanks a lot and sorry my english.