checklists

[devilonline]

Hi, I have an data base like this. How by instance chose Jonh and then only show on the scroll down list of jonh

thanks

Untitled.jpg

[David A Coop]

Hi DevilonLine,

Are you really still using XL2003, or is your profile out of date?

You can highlight the cells below Jonh and in the Names box, type Jonh. (This is the white box above the row headings. Press enter. You have now named the range.

Select the range of cells you want the drop down list to appear.

Under Data, select Validation, in the Allow box, select List

Now in the Source box type =Jonh then press OK.

YOu will now have a drop down list in all the cells you had selected.

Repeat the process for the other lists.

I hope this helps, please let me know!

Regards,

David

Please remember, your request is clearer if you attach a sample workbook.
- Click on Go Advanced and click on the Paper Clip.
When you reply please make it clear WHO you are responding to by mentioning their name.
If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

[devilonline]

Untitled23.jpg

Hi. what i want is to the first choice determinate the items of the second choice.

thanks

[David A Coop]

devilonline - Checklists.xlsx

Hi devilonline,

I have attached a workbook which I hope will give you a clue!

I hope this helps, please let me know!

Regards,

David

If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

When you reply please make it clear WHO you are responding to by mentioning their name.

[sktneer]

Please find the attached sheet to see if this is what you want.

[David A Coop]

Have not heard how you got on, or whether my suggestion was what you wanted! Will be away for a few days, so will be unable to provide a quick response.

All the best,

David