| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with getting data from a worksheet
Hi, I have 2 excel sheets username sheet --------------- it contains just usernames in one column main sheet ----------- i want to chose from a listbox, combobox, or whatever one or more usernames from the username sheet. How can i do that?? another question: I want to be sure that every username has one instance only can you help be? BogN, -- BogN ------------------------------------------------------------------------ BogN's Profile: http://www.excelforum.com/member.php...o&userid=34979 View this thread: http://www.excelforum.com/showthread...hreadid=547173 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with getting data from a worksheet
"BogN" wrote: Hi, I have 2 excel sheets username sheet --------------- it contains just usernames in one column main sheet ----------- i want to chose from a listbox, combobox, or whatever one or more usernames from the username sheet. How can i do that?? another question: I want to be sure that every username has one instance only can you help be? BogN, -- BogN ------------------------------------------------------------------------ BogN's Profile: http://www.excelforum.com/member.php...o&userid=34979 View this thread: http://www.excelforum.com/showthread...hreadid=547173 Create a named range for your username list and then set the ListFillRange property of the control to the name you just defined. The removal of duplicates can only be done by modifying your list as there is no setting to do this in the control. Does the username list change? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a graph and use the data in the new worksheet? | Charts and Charting in Excel | |||
| Ignoring Rows When Extracting Data From One Worksheet To Another | Excel Worksheet Functions | |||
| Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
| Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
Linear Mode
