Independent Lists...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Corey said:
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?
Click to expand...

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
 
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?
 
Back
Top