drop down list 11-24-09

Hi 
How can I create a drop down list which is on a separate worksheet but in 
the same file? The name of the worksheet is Idaunits. And I want the drop 
down list on a separate worksheet named WCU Sept.
Thanks
1I1A
1I1B
1I2
1I3
1I4
1I4A
1I4B
1I5
1I6
1I96
1I97
1I98
1L20
1L40
1L50
1Z2
1Z3
2I1
2I1A
2I1B
2I2
2I3
2I3B
2I4
2I4A
2I4B
2I5
2I6
2I96
2I97
2I98
2L20
2L40
2L50
2Z2
2Z3

0
Utf
11/24/2009 8:57:03 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
769 Views

Similar Articles

[PageSpeed] 45

Goto Insert - Name - Define.
Select your range of cells with your list, and give it a name (MyRange). 
Click Add, Ok out.

On your other worksheet, goto Data - Validation - List
Input the following:
=MyRange

Ok out. 
-- 
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"da" wrote:

> Hi 
> How can I create a drop down list which is on a separate worksheet but in 
> the same file? The name of the worksheet is Idaunits. And I want the drop 
> down list on a separate worksheet named WCU Sept.
> Thanks
> 1I1A
> 1I1B
> 1I2
> 1I3
> 1I4
> 1I4A
> 1I4B
> 1I5
> 1I6
> 1I96
> 1I97
> 1I98
> 1L20
> 1L40
> 1L50
> 1Z2
> 1Z3
> 2I1
> 2I1A
> 2I1B
> 2I2
> 2I3
> 2I3B
> 2I4
> 2I4A
> 2I4B
> 2I5
> 2I6
> 2I96
> 2I97
> 2I98
> 2L20
> 2L40
> 2L50
> 2Z2
> 2Z3
> 
0
Utf
11/24/2009 9:01:04 PM
Thank you. It worked.

"Luke M" wrote:

> Goto Insert - Name - Define.
> Select your range of cells with your list, and give it a name (MyRange). 
> Click Add, Ok out.
> 
> On your other worksheet, goto Data - Validation - List
> Input the following:
> =MyRange
> 
> Ok out. 
> -- 
> Best Regards,
> 
> Luke M
> *Remember to click "yes" if this post helped you!*
> 
> 
> "da" wrote:
> 
> > Hi 
> > How can I create a drop down list which is on a separate worksheet but in 
> > the same file? The name of the worksheet is Idaunits. And I want the drop 
> > down list on a separate worksheet named WCU Sept.
> > Thanks
> > 1I1A
> > 1I1B
> > 1I2
> > 1I3
> > 1I4
> > 1I4A
> > 1I4B
> > 1I5
> > 1I6
> > 1I96
> > 1I97
> > 1I98
> > 1L20
> > 1L40
> > 1L50
> > 1Z2
> > 1Z3
> > 2I1
> > 2I1A
> > 2I1B
> > 2I2
> > 2I3
> > 2I3B
> > 2I4
> > 2I4A
> > 2I4B
> > 2I5
> > 2I6
> > 2I96
> > 2I97
> > 2I98
> > 2L20
> > 2L40
> > 2L50
> > 2Z2
> > 2Z3
> > 
0
Utf
11/24/2009 9:11:02 PM
Reply:

Similar Artilces:

Filling drop down box
hi, I have a drop down box in a cell. Based on a value of anohter cell I have to fill my drop down box. what i mean is, say if GreeNPackage is "No" then I want the drop down box to fill a range of values. But if the GreeNPackage is "Yes" then I want the drop down box to fill another set of values. how can i do this? plenty of thanks See reply in .Functions Biff >-----Original Message----- >hi, > >I have a drop down box in a cell. Based on a value of >anohter cell I have to fill my drop down box. what i mean >is, say if >GreeNPackage is ...

Job Listing- VC++ MFC with Isofttech
Position: Technical Lead Experience: VC++/C++ with MFC Good to have: Wireless 802.11 Skills & Windows development experience. 5-6 years of experience. Work Location: Chennai Education: BE/B Tech, ME/M Tech ( CS,IT,ECE,EEE) Do send in your CV to sridhar.doss@consultniche.com thanks s.doss niche consulting ...

Listing Activesynce users
Is there a way to list the users who are actually using Activesync? I can get a list of all the devices but have not run across a method of seeing if they are actually sending and reciveing mail. Thanks. Jeff In news:Oi0wwKTaGHA.1204@TK2MSFTNGP04.phx.gbl, Jeff Senter <jsenter@erols.com> typed: > Is there a way to list the users who are actually using Activesync? I > can get a list of all the devices but have not run across a method of > seeing if they are actually sending and reciveing mail. > > Thanks. > > Jeff Check out http://www.microsoft.com/downloads...

enter value based on drop down list of another field?
I have an excel 2003 spreadsheet with 3 worksheets. In sheet 1, I created a drop down list in column A based on values in sheet 3, column A (item number). Thisd data comes from sheet 3, where I have column A (Item #'s), column B (Item desc)an Column C (price) In column B of sheet 1, I have Item Descriptions and in column C I have price. I want this to automatically fill in based on what I enter in the column A sheet 1 and it should get the corresponding values from sheet 3 column B and C. I can make the drop down list in sheet 1 column B and C, but some of the descriptions need ...

Image List
Hello All I Need To Get The Path Of The Image Saved In An Image List Any One Know How Thanks Start Run Browse to the field Select view all field types Select open Cut the path from the box Close run Be aware the you will have extra "" around the path (just in case you are using the path in a code) Good luck -- Wayne Manchester, England. "RABEA" wrote: > Hello All > > I Need To Get The Path Of The Image Saved In An Image List > > Any One Know How > > Thanks > > > I'm not sure whether this info is retained but even if it ...

Mailing List Duplicates
Is there a software program that works with excel to delete duplicate names? Our mailing list is in the thousands. Thanks for any and all help. Gordon habitated@gulftel.com one way? data>advanced filter, copy to another location and unique records only "Gordon" <habitated@gulftel.com> wrote in message news:032201c3796f$ab75f130$a401280a@phx.gbl... > Is there a software program that works with excel to > delete duplicate names? Our mailing list is in the > thousands. Thanks for any and all help. > > Gordon > habitated@gulftel.com ...

combo box list updating
Hi - I would like my combo box list to change base on the value of A1. That is, I have its input range being B1:F1 - "Year 1", " Year 2" etc. Example: -If cell A1 is the value "10" then the combo box default list item would be "Year 1" (which is cell "B1") -If cell A1 is the value "20" then the combo box default list item would be "Year 2" (which is cell "C1") ETC... Thanks for your help - Jim A ...

C#, .net 3.5sp1 and Visual Studio 2008 sp1 errors list
What kind of errors will the errors list show when using C# 3.5sp1 with Visual Studio 2008sp1? "Andy B." <a_borka@sbcglobal.net> wrote in message news:%23tmIzu4vKHA.404@TK2MSFTNGP02.phx.gbl... > What kind of errors will the errors list show when using C# 3.5sp1 with > Visual Studio 2008sp1? e Why would you expect any? On the face of it vs 2008 sp1 will target .Net framework 3.5 sp1 by default. Andy B. wrote: > What kind of errors will the errors list show when using C# 3.5sp1 with > Visual Studio 2008sp1? That all depends on what ki...

Identities 12-18-09
I get a message box when trying to open my Windows Mail. It states Dial up Connection, which service do you want to use, automatically connect, connect, settings, cancel. This occurred when I downloaded Internet Explore 8. I used to have a dial up connection in virginia, however I am high spped Internet here in Michigan. I can not send or receive emails now, and can't get rid of that box. Go to Tools, Accounts, select your mail account, Properties, Connection. What does it show for connection? You should leave that setting unselected, in which case WM will use=20 whateve...

CObarray and list
Can any one give me some pointeres? I have a CObArray, say, with 4 items. I have a list box, of which the content is generated from the string variables of the 4 items. The list box is sorted alphabetically. When a users clicks on an item in the list box, what's the best way to reference back to the original array, i.e which array has been selected? I can't use GetCurSel() as the list box is sorted alphabetically. I can't do a direct comparison either as the list items are generated from a bunch of variables within each array object. In some cases, it may be possible for dupli...

need help with list box?
Hi I have a huge table of about 20000 records. how can I restrict entry for a few columns. I am new to excel programming. For example. I have a list of colors (red, green, blue) that I want to go under the Color column. how can I allow the user to click on a pulldown or list box similar to ms access for each cell. thanks in advance. Hi you could use 'Data - Validation'. See: http://www.contextures.com/xlDataVal01.html >-----Original Message----- >Hi > >I have a huge table of about 20000 records. how can I restrict entry for a >few columns. >I am new to exc...

List all row source for all forms, reports etc.
Hi I'm doing some work cleaning out old unused forms, reports and queries. I have been going through each report in a database (There are A LOT), determining its row source query, then marking it for deletion. I will eventually end up going through and deleting all the unused queries. As you can imagine this is time consuming, and I was thinkg 'there must be a FASTER way" Does anyone have a suggestion, or link to a pre-built function or model that could assist me? Regards Darragh On Thu, 17 Jan 2008 22:14:18 -0800 (PST), Darragh <darragh.murray@gmail.com> wrote: >Hi...

Some contacts don't show on drop down box when addressing email
I was using Outlook Express, my computer motherboard died, got new computer with Windows 7, trying to learn Outlook 2003. The computer tech from my husband's office put Outlook 2003 on the new computer and somehow transferred the addresses that I had in Outlook Express. I do not know what method he used to get the addresses into Outlook 2003. Some things carried over just fine, some things didn't, i.e. a group list of my subdivision property owners, so I had to re-make that distribution list. When I want to email my daughter, her name or email address is not s...

Drag Drop problem in CListCtrl
Hello , I have a CListCtrl which displays the thumbnail view of image files & other related info like file size , destination.The owner drawn property of the list cntrl is set to true. I want to be able to drag - drop the thumbnails within the list view itself. But the dragged image of the selected list item is always displayed as a black bitmap.I have used CreateDragImage , BeginDrag , DragEnter , DragMove etc for this.Why is this problem ocurring???? Also if instead of having the dragged image of the item to be displayed , i have set a default bitmap, but it too doesn't get displa...

MSN account list
How come I can't get a CASH account to show up in MSN. I want to enter transaction on MSN site from work and on the road, and sync them when I get home. ...

list view problems
hi all basically I have a few questions CListViews that I'm trying to use: 1. are the rows uniform in height, and rowheight cant be adjusted? 2. How can I set column width as per my wish. i tried SetColumnWidth and LVCOLUMN structure 3. is there a setting so users cannot resize the column or in other words make column width fixed? Thanks a lot. Harish 1. There are several ways by which you can set the row height of a list control. Create an owner-draw list control and handle the WM_MEASUREITEM message, and set the itemHeight attribute of LPMEASUREITEM struct. Create a C...

getting consolidate list of "follow up" items
Dear All, I would like to get a consolidated list of items (sent and received mails)that have matured - i.e. whose follow up time is up. I have the habit of tagging a sent mail (after actually sending) for follow up. Similarly, mails received are also tagged for my further action (for follow up). Would appreciate a consolidated follow up report generation way - rather that opening each folder and looking for mature items (i.e. red). Thanks in advance. Sanjay ...

Name AutoCorrect 09-26-03
I am running Access2000 and working on an existing database (I believe it was converted from FoxPro). I have turned on the Name AutoCorrect options (in Tools > Options > General), however, Name AutoCorrect does not work. I searched KnowlegeBase and found a report 230616 which explained that for a "converted database", I need to save each control that I plan to change, in order to generate the Name Map. I have done that, but Name AutoCorrect still does not work. Any help? Not 100% sure but... 1. Can you create a new .mdb, set the NameAutoCorrect, and import the objec...

query to make a list of products based on delivery history
I have a table which lists all deliveries made of our product. From this table, I'd like to make a list of all products. My problem is the products will have many duplicates as they can be ordered multiple times and I just want a list showing all the individual products that we offer. -- TIA Try something like: SELECT DISTINCT [our product] FROM [which list all deliveries made]; If you can't figure this out, come back with table and field names. -- Duane Hookom Microsoft Access MVP If I have helped you, please help me by donating to UCP http://www.access.hookom.net/UCP/Def...

Drop Down List in a Cell
How do I get the drop down arrow to stay in the actual cell that I have the info in? It only shows up when you click on the cell and the arrow is outside of the cell. Thanks for any help. That's how data validation works. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "Mike" <Mike@discussions.microsoft.com> wrote in message news:A0546DF8-1E97-4D93-A46E-D718A3C4F00D...

Changing icon for list item
Hi all, I would like to change the icon for the first column of the list control in report view. Right now, the method I used is remove the LVITEM at that location and reinsert at the exact same place with a different icon. I know this is not efficient compared to directly changing the icon. I had tried GetItem adn SetItem but even though i specified a different icon using the index into the imagelist, it still won't change. Could someone please enblighten me on this? thank you very much. Hallo Lonewolf! > I would like to change the icon for the first column of the list &...

Distribution List #2
I created a distribution list on exchange server. Now I add up some members from the address list but I dont know how to add users who are outside our site. How can I add those users in any list so that I can pik it up from there. Thanks in advance. You need to first add them to the Exchange GAL. In exchange 5.5 you would add a new custom recipient. In 2000 or 2003, you add a mail enabled contact. Then you can select them from the GAL when updating the DL. -- hth, SusanV "khan" <anonymous@discussions.microsoft.com> wrote in message news:00f901c3c337$25a0d220$a401280a@phx....

11 Best Xyzu Wallpaper About Mountain at China.exe (7/7)
=ybegin part=7 line=128 size=1593929 name=11 Best Xyzu Wallpaper About Mountain at China.exe =ypart begin=1497601 end=1593929 �C[=@a=}�/��`�5Ҵ�b��,�'���r�?������/��3NV���q���w�3x��`A���7,$D2=J_SOfu�4p�"��Z&N�褜#-n���̷�@��r�/��5�QҬу��� I͠)?{7@�%��[�ym�z��^�~�:���ڑYdkŝ��� Dx���@3��8�p+�"y��$E�ޓeْ2�b<=}STTY]�=@T9W�6����P�%��C��^o�x+1��c�5[O|N�I�KD xb��1Œ�bz$Ӭk�#⺶H���C:��h��,E�?�\?���~��0볈�j�+���T���ay�$���Y%��-��5���<=}�i+�?O�7�#�m�%V�d��9Bc>Qv_;=}�V��w� ��&�S�F6����3���/;^�n�x��=J���>�$��H���WK�\�-�v�+:dyw�=J��A���n��...

Distribution Lists #24
I have four distribution lists in Contacts. When someone emails me and asks to be put on a list, I add them to Contacts, then go open that list, click on "Select Members" and add that person. It works , but seems a bit labour-intensive. Is there a way of adding a contact to an existing list from within that person's contact details? I can make a _new_ distribution list from the "Actions" menu, but surely I should be able to add the person to an existing list? Am I missing something obvious? TIA paul You can add a new contact from within a distribution list ...

help 02-24-06
Hello, I need help from you. Yesterday,I find out a problem about Microsoft CRM. I realised that I have no apportunity,that when I got mail from my customer with a problem. I decidet to make a case directly from the recepient mail.I can only convert the mail into Opportunity. But I need a solution,so I can streight from the incomming mail make a case form that customer. If someone can help me,I would be thankfull. Sara The only way I know of to achieve this is either write your own code to do this and make a button for it on the activity form through ISV (if activities are now supported) o...