Link two xls documents

[Hartenberg]

Hi everyone.

I would like to know how to create a scroling down menu in a cell which has all its options located in a different document. Each scroll menu should be able to trim item list depending on what have been selected on last scroll menu.

For example, I have a document named Material_list.xls who contain list of item ( description, prices, model number.. etc). Each sheets have is own manufacturer ( sheets name is the manufacturer name ).

On the other document, named Project_list.xls, the user should choice on a scroll list the manufacturer ( who the name of Material_list.xls sheets) . In the model cell, the scroll list should only select item corresponding to this choice ( all item under Material_list.xls manufacturer selected sheet).

I know that is not an easy thing, but if someone can give me some clue about how to proceed with "linkage" between these 2 documents I will really appreciate it.

Thanks

[Big Chris]

Hey Hartenburg,

Don't think the attached is exactly what you're looking for (I think you probably need some macros to acheive that), but it might help you get to where you want to be as there are no other responses.

HTH,

Big Chris.