 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2008Drop List help
Is it possible to create a drop list of all the states that allows you to pick which state you want to enter? I will be using it with the wage entry page I have been working on just to enter in the state that I will be working in Is this for a userform or an embedded object on a worksheet? If it is for an embedded object on a worksheet... here is one scenario. List all the states in a far off column (ie - Column IV) In the cell you want to pick a state select DATA | VALIDATION | ALLOW:= "LIST" | SOURCE:= Range IV1: IV50... This is just an example, but it might get you started. Mark Ivey > Is it possible to create a drop list of all the states that allows you to > pick which state you want to enter? > I will be using it with the wage entry page I have been working on just to > enter in the state that I will be working in I have not reseived a responce yet On this issue So incase it is because I confused anyone I will try to explain what I want to do abit better the idea I have with the drop list is I should be able to create a worksheet for each state to enter in my wage info for the year and all other info corrisponding to the state by using a drop list if there is such a thing for excell how I want to set it up if there is such a thing as a drop list I would use it to call up which ever states work sheet and then and have the info entered in that worksheet from the feilds in my weekly entry sheet? if this is possible could some tell me whether or not it would work? > Is it possible to create a drop list of all the states that allows you to > pick which state you want to enter? > I will be using it with the wage entry page I have been working on just to > enter in the state that I will be working in You have already received a reply, Buzz, which told you how to do it by using Data | Validation. Put a list of 50 states in column A of a new sheet and then give this range a name (eg States) using Insert | Name | Define. Then put other pertinent data in other columns next to the names. On your timesheet you can set up a pull-down in a cell by clicking on Data | Validation and set Allow to List and then specify States as the source. This cell can then be copied down. If you need to bring other related data from the other sheet you can use the VLOOKUP function. Here's a couple of links that will give you more details: http://www.contextures.com/xlDataVal01.html http://www.contextures.com/xlFunctions02.html Hope this helps. Pete > I have not reseived a responce yet On this issue > So incase it is because I confused anyone I will try to explain what I want [quoted text clipped - 14 lines] > > - Show quoted text - Hey Pete Thanks I just finnished it and it works great well the list and the totals gross income you were very helpfull I have a few more things I am wanting to do but I think I will try abit harder to work them out myself You have already received a reply, Buzz, which told you how to do it by using Data | Validation. Put a list of 50 states in column A of a new sheet and then give this range a name (eg States) using Insert | Name | Define. Then put other pertinent data in other columns next to the names. On your timesheet you can set up a pull-down in a cell by clicking on Data | Validation and set Allow to List and then specify States as the source. This cell can then be copied down. If you need to bring other related data from the other sheet you can use the VLOOKUP function. Here's a couple of links that will give you more details: http://www.contextures.com/xlDataVal01.html http://www.contextures.com/xlFunctions02.html Hope this helps. Pete On Apr 22, 12:52 pm, "Buzz Local#30" <ba...@kaycopets.com> wrote: > I have not reseived a responce yet On this issue > So incase it is because I confused anyone I will try to explain what I [quoted text clipped - 24 lines] > > - Show quoted text - You're welcome, Buzz - thanks for feeding back. The newsgroups are here to help people with Excel problems, so come back anytime you need to. Pete > Hey Pete Thanks I just finnished it and it works great well the list and the > totals gross income you were very helpfull [quoted text clipped - 53 lines] > > - Show quoted text -
|
Reply to this Message |
 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.