sort by name when user selects name on another worksheet
Is there any want to select a value on one worksheet, using a pick list, and
having that sort data by the name on another sheet? For example in a sheet
named €śStart Here€ť Cell B3 has a pick list with names in it, like Joe, bill,
bob, henry etc. If the user selects Joe on that worksheet, then another
worksheet named €śEmployees Info 2-25-10€ť is sorted by that name, i.e. Joe?
Is this possible, if so how? Any help would be appreciated!
|