Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2008

Tip: Looking for answers? Try searching our database.

Different need for a list

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Elmo Watson - 22 Jan 2008 17:15 GMT
I need something like a List in Excel - but it's not technically for sorting
and I don't want it at the header line.

Picture a regular application with a Dropdownlist/combobox
This list has a lot of items in it, that I want to choose from on every line

So it's like this:
Header: Item -------------Column2Header----Column3Data
(choose from dropdown) - column2  Data- ---------column3 Data

I need to copy the dropdown on every new line, to choose from that list,
what's relative to the data in that line for Column2 and Column3

Any ideas on how this can be done (or if) in Excel?
Dave Peterson - 22 Jan 2008 18:26 GMT
Maybe you could use Data|Validation and use dependent lists.

See Debra Dalgleish's site for some instructions:
http://contextures.com/xlDataVal02.html

> I need something like a List in Excel - but it's not technically for sorting
> and I don't want it at the header line.
[quoted text clipped - 10 lines]
>
> Any ideas on how this can be done (or if) in Excel?

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.