Drop down list in Excel

[SamDemon]

Could someone please tell me how to make a cell look to a different sheet in order to use in a drop down list, thats if it's possible. Or any other solutions would be gratefully appreciated.

SAM

It's just common sense, shame sense isn't common!

 

[KenWright]

Name the list in the other sheet using Insert / Name (Assume you have named it MyList).
Then on the sheet you want to create your list, use Data / Validation / List, then type =MyList in the reference box and hit OK

Regards
Ken................

 

[SamDemon]

Thanks for that Ken, worked brilliantly. Could you tell me though if it is possible to give a different value in one cell depending on one chosen from the drop down list?
i.e. 1st Class chosen ---- 26p
Recorded Delivery --- £3-50

Regards SAM

It's just common sense, shame sense isn't common!

 

[Bowers74]

Hi SAM,

Check out this thread:

thread68-642850

It deals with just that!


I hope this helps!

Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[SamDemon]

sorry, i'm having a little difficulty with this is there anyway i could forward the file onto you?

It's just common sense, shame sense isn't common!

 

[Bowers74]

For a star, I will do anything ;-)

vbaprogrammer@etisnikcufecin.com

If the file is large (> 1 MB) then put it in a ZIP file to speed things up a bit!



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[SamDemon]

sorted it, you can have a star anyway.

Cheers mate

Sam

It's just common sense, shame sense isn't common!

 

[Bowers74]

I'm glad you got it working!

Peace!

Mike

Never say Never!!!
Nothing is impossible!!!