Drop List help

  • Thread starter Thread starter Buzz Local#30
  • Start date Start date
B

Buzz Local#30

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
 
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?
 
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
 
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
 
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
 
Back
Top