Named Arrays referenced across worksheets

[Cfreehill]

Hi,

In ExcelIsFun video 548 (see link below), it is explained how to refer to a named table from another worksheet. I tried to do this on Excel 2007, but was not able to. I was wondering anyone knows of a what to do this, or knows that it can't be done.

http://www.youtube.com/watch?v=dk-l80bBa4g&feature=email&email=comment_reply_received

Thanks for your help,

Chris

 

[CharlesH]

Hi,

Welcome to the forum. You can create a dropdown in sheet1 and have it refer to another worksheet. the below is what I used for the dropdown in sheet1

=Sheet2!$A$1:$A$6

 

[mole999]

In the Ribbon, > Formulas > Name manager