Hi, I'm a newbie to the macro world and quite illiterate.
I have an excel file where Column A is a huge list of music artists (5000 and counting) and Column B is the artist "tag", i.e. the music genre the artist plays. When I click on the macro button, I wanna get a random artist but not totally random, it's gotta be within the genre that the button is intended for. In my example (see picture below) it's a "random rock artist" button and I entered 10 different artists and 5 different genres (the rock artists are 3, so in this short example I'll have one random rock artist). The result should show on another cell, for example D7. What's the macro code I should use? Thank you!
I have an excel file where Column A is a huge list of music artists (5000 and counting) and Column B is the artist "tag", i.e. the music genre the artist plays. When I click on the macro button, I wanna get a random artist but not totally random, it's gotta be within the genre that the button is intended for. In my example (see picture below) it's a "random rock artist" button and I entered 10 different artists and 5 different genres (the rock artists are 3, so in this short example I'll have one random rock artist). The result should show on another cell, for example D7. What's the macro code I should use? Thank you!