Levels

[Peterkroon]

Hi I have a spread sheet with over 300 names each name has a score (number) I also have a table with 4 levels each level has a number range eg: 14-45. What I am trying to do is pull the names of which level I select eg: level 2 is a range of 6- 12 so I should be able to see all names with a score between 6-12. But I can’t seem to work it out for the life of me. Any help would be much appreciated

 

[KolGuyXcel]

How are you trying to "select" the range? From the validation drop down list in a particular cell?

And how are trying to "pull" the names? Or rather should I ask how are you trying to get the results displayed once a range is "selected"? A static tabular form? Or a dynamic column display which only displays the relevant names removing the names from earlier "selections"?

 

[Logit]

.
You can do this without VBA or Formula ... use the built-in FILTER ... on the MENU BAR select : Data / Sort & Filter / Filter

https://support.office.com/en-us/ar...or-table-01832226-31b5-4568-8806-38c37dcc180e

 

[Peterkroon]

That’s the thing I haven’t been able to set it up correct yet I was going to use a drop down but I’m thinking that won’t work if I have 2 numbers in there cause I’m thinking excel will read it as one number

 

[Peterkroon]

I was thinking of using filters but once my boss takes this project over he won’t have a clue what he is doing so was hoping to make it a little user friendly

 

[Logit]

.
You can use the MACRO RECORDER to create the various macros you are seeking.

First, click on RECORD MACRO.
Then go through the motions of creating the FILTER and selecting the first level, then end the macro.
You can attach a command button to this macro, paste a commandbutton on the main sheet.
When you click the button, that macro will run and filter the columns as required.

Repeat the process for each FILTERED level, creating a different button on the main sheet to run it.

Name each button for the different levels.

You can create one last macro, that will clear all the filters and return the sheet to its original state.