amoverton2
Board Regular
- Joined
- May 13, 2021
- Messages
- 77
- Office Version
- 2016
- Platform
- Windows
Hi!,
First off, Akuini has been helping me a lot, thank you for being so good at excel and willing to help! I'm understanding slowly but building my knowledge base.
How can I display everything that is on the Enlisted Sponsor Pool sheet in a listbox (in userform ESP, in the file below) with dependent combo boxes to filter data where the listbox shows only shows the filtered data.
However this is not like before where I wanted specific data, I would like to be able to filter all data on the sheet.
For example; first filter is UIC, next filter is Paygrade, next filter is Code, next filter Qualified. I only need a max of 4 filters.
The reasoning behind the listbox is because I work at a place where people routinely screw stuff up, where it's password protected or not and I want to limit their about to screw things up. Clicking a button and having a userform listbox show up with data already in that they can filter but not change a thing would benefit me in the long run, vice hunting through spreadsheets.
File:
First off, Akuini has been helping me a lot, thank you for being so good at excel and willing to help! I'm understanding slowly but building my knowledge base.
My next challenge that I'm having a hard time figuring out and someone with a better understanding probably knows. So here we go!How can I display everything that is on the Enlisted Sponsor Pool sheet in a listbox (in userform ESP, in the file below) with dependent combo boxes to filter data where the listbox shows only shows the filtered data.
However this is not like before where I wanted specific data, I would like to be able to filter all data on the sheet.
For example; first filter is UIC, next filter is Paygrade, next filter is Code, next filter Qualified. I only need a max of 4 filters.
The reasoning behind the listbox is because I work at a place where people routinely screw stuff up, where it's password protected or not and I want to limit their about to screw things up. Clicking a button and having a userform listbox show up with data already in that they can filter but not change a thing would benefit me in the long run, vice hunting through spreadsheets.
File:
amoverton2 - 2.xlsm
drive.google.com