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 mor
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

--
Bog
-----------------------------------------------------------------------
BogN's Profile: http://www.excelforum.com/member.php...fo&userid=3497
View this thread: http://www.excelforum.com/showthread.php?threadid=54716

Help with getting data from a worksheet
 

If you give your username list a name (named range) You colud use Data,
Validation, Allow, List and in the Source box type =YOUR NAMED RANGE.

HTH

Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=547169