Independent Lists...

[Corey]

I am familiar with creating lists in excel, however, I need help on a
formatting issue. Once I have more than one list, I can select an item from
one list without it automatically pulling an item in another list from the
same corresponding row. Is there a way to get my lists to act independently
of each other?

 

[Dann Pedersen]

I am familiar with creating lists in excel, however, I need help on a
formatting issue. Once I have more than one list, I can select an item
from
one list without it automatically pulling an item in another list from the
same corresponding row. Is there a way to get my lists to act
independently
of each other?

It sounds to me like you have more than one list in a worksheet. In fact it
sounds like you have two or more lists on the same rows but in different
colums. This is not a good idea, since filtering, row selection and other
things probaly won't work the way you expect it to. Unless you are absolutly
sure why you want this special functionality, you should always abide by the
rule that you only have one list per worksheet.

Hope this helps.

/Dann

 

[Casey]

Corey,
Are your lists created through Data Validation?
I trying to understand why when you select an item in one list it
automatically selects something from another list???
Normally unless you have created dependant lists, selections in another
list shouldn't be effected. Can you give some more detail about the
workings of your lists?