From: Corey - view profile
Date: Wed, Jul 5 2006 1:19 pm
Email: "Corey"
Groups: microsoft.public.excel.misc
Not yet ratedRating:
show options


Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse | Find messages by this author


Is there anyway that I can have several lists in a given worksheet so
that they act independently on each other, not simply dependent on the
primary list? I would like to select certain info from one list,
certain info from another, and so forth, without being limited to the
info soley in the row of the initial info selected. Help!

Reply »


From: Nick Hodge - view profile
Date: Wed, Jul 5 2006 1:31 pm
Email: "Nick Hodge"
Groups: microsoft.public.excel.misc
Not yet ratedRating:
show options


Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse | Find messages by this author


Corey

In XL2003 there is list functionality under the data menu


These defined lists can be sorted independently and referenced in
formulae
independently, etc.


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk




"Corey" wrote in message


ups.com...


- Hide quoted text -
- Show quoted text -

Is there anyway that I can have several lists in a given worksheet so
that they act independently on each other, not simply dependent on the
primary list? I would like to select certain info from one list,
certain info from another, and so forth, without being limited to the
info soley in the row of the initial info selected. Help!


Reply » Rate this post:



|||||||||||||||||||||||||||||||||||||||||||||||||| |||||||||||||||||||||||||||||||||||||||||||||||||| ||||||||||||||||||||||||||||||||||||||||||||||||||

I can create two different lists with no problem, however, I can't
select one item from one list without it pulling up an item in the
other list in the corresponding row. Is there any way to get two or
more lists to act independently of eachother?