Imdabaum
05-28-2010, 09:27 AM
I'm still new to developing in Excel and need some help.
I've gone to the developer tab and inserted a drop down tool. I want to populate this control and when a user is selected, I want to apply a filter on column C by that user name.
I know I can easily hit the soft&filter button on the ribbon, but I want something that only filters the username and not all the other columns.
I'm going to be sending out a spreadsheet with various users on it and want them to only filter the names and complete the data entry.
I've gone to the developer tab and inserted a drop down tool. I want to populate this control and when a user is selected, I want to apply a filter on column C by that user name.
I know I can easily hit the soft&filter button on the ribbon, but I want something that only filters the username and not all the other columns.
I'm going to be sending out a spreadsheet with various users on it and want them to only filter the names and complete the data entry.