Group:  Microsoft Excel ยป microsoft.public.excel.newusers
Thread: Independent Lists...

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Independent Lists...
Corey 05.07.2006 19:54:02
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?
Re: Independent Lists...
"Dann Pedersen" <dann_pedersen[ at ]bigfoot.com> 06.07.2006 06:29:42
"Corey" <Corey[ at ]discussions.microsoft.com> wrote in message
news:A7A9C741-54C1-440F-9C49-8A80DE7277CA[ at ]microsoft.com...
[Quoted Text]
>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


Re: Independent Lists...
Casey <Casey.2aqry1_1152555564.5521[ at ]excelforum-nospam.com> 10.07.2006 18:17:31
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? -- Casey ------------------------------------------------------------------------ Casey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=4545 View this thread: http://www.excelforum.com/showthread.php?threadid=558630

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net