Independent Lists...

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" <[email protected]> wrote in message
news:[email protected]...
>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