Depending list - excel 2007

[Weronika]

Hi All,
I have just quick question, have a spreadsheet with data based on depending list i'm just wonder is it possible to get all of data show stright after choose the value in col A?

Thanks for any help.
Weronika

 

[Manohar M G]

Hi,

Can you explain with example.

 

[Weronika]

Hi thanks for reply, what i need is:
when i choose id number in col A i would like to get straigtaway description in col B and pack size in col K which are link together by depending list.

Thanks a lot for any help.
Weronika.

 

[Manohar M G]

Hi,

It is better go for filter... you will get it.. its not required to write a macro for that..

 

[Weronika]

Hi,
I can not use filter because it is empty form which i need to fill in. It's why i need to apear all of data when i choose value in col A.

Thanks,
Weronika

 

[grizz]

you should be able to use a Vlookup or Index / Match

 

[Yahya]

see if this link will help
http://www.mrexcel.com/forum/showthread.php?t=512691

 

[Weronika]

Hi All, thanks for reply, but i think i didn't explain what i need clear enough, sorry about that. Let's try again. I have empty form which i need to fill in. I have depending lists in there so when i choose article in col A i have description for this in col B and what i would like to get is: when i choose article i wish to description apear straightaway and the same for all of them where on the list is only one choice for this article.
Hope it is better now.
Thanks,
Weronika

 

[Yahya]

did you see my link
there is another link
http://www.contextures.com/xlDataVal02.html

and if this is not what you want please
post small sample from your data

 

[Manohar M G]

Hi,

I have one question :

1. You will fill ID in column A manually.. or it will be in drop-down list..

It is better to post the excel file..