Unsolvable - Displaying Named Ranges based on Clicking a Cell
Posted on 2004-08-11
How do I move only the names into a another sheet but I want them to be in a 3 columns instead of one long column?
And then when you click on a name, it will display it's range a few columns over. Picture this.. a list of names and when you click on the name, all of the person's data is displayed, which IS already defined. I have the named ranges defined (insert menu > names > define). Any sample code on how to do this?
A .. J
John Smith data
Jane Doe data
Mike K. Jordan data
<<Points refunded (500) because user answered question himself
byundt--Excel TA Page Editor>>