list from another workbook

[tikchye_oldLearner57]

hi community

i can get a list (range of cell with data) from another worksheet in the
same workbook ..... I gave the range cell a Name and after that I use that
'Name' to fill in the source from the List dialog box...
can...
I get a list from another workbook ?

 

[Gord Dibben]

Have you tried?

Yes, you can, although the other workbook must be open.

See Debra Dalgleish's site for info.

http://www.contextures.on.ca/xlDataVal05.html


Gord Dibben MS Excel MVP

 

[tikchye_oldLearner57]

thanks Gord Dibben very helpful indeed

and to community as well

thanks!