Help with getting data from a worksheet

B

BogN

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
 
P

Paul Lautman

BogN said:
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??
Click to expand...
Bring up the Forms toolbar. Decide whether you want a listbox or a combobox,
click it, then click where you want it on the sheet. Right click the box and
select Format control. Select the range with your usernames for the Input
range.
another question:
I want to be sure that every username has one instance only
Click to expand...
Data->Filter->Advanced Filter... then tick Unique records only
 
D

dbahooker

you can do really complicated, limited if - then statements

if thisPage = 'aaron', Sum(A1:B9), if thisPage = 'matt', Sum(A2:B36),
0)

I had to do complicated if- then statements like this all the time when
i worked at microsoft.. definitely one of the reasons that i hate excel
so much; in access this would be much much much easier

-Aaron
 
P

Paul Lautman

you can do really complicated, limited if - then statements

if thisPage = 'aaron', Sum(A1:B9), if thisPage = 'matt', Sum(A2:B36),
0)

I had to do complicated if- then statements like this all the time
when i worked at microsoft.. definitely one of the reasons that i
hate excel so much; in access this would be much much much easier

-Aaron
Click to expand...

What ARE you talkng about??? This has nothing to do with the OP's
question!!!
I have noticed that your posts are never helpful. Do you ever have anything
useful to say?

This forum is for people to get help using Excel. The fact that Microsoft
distribute Excel in many Office packages but Access in only a few is why
many more people use Excel than Access. Personally, if I have an application
to build that requires a real database, I choose to run an apache server on
my machine and build the app using MySQL (or PostgreSQL) and PHP (or ASP).
Then I could allow easy access via a web browser to any machines on any
interconnected network. I certainly wouldn't use Access.

If you don't have anything helpful to say, do everyone a favour and don't
say anything!
 
Top