I am trying to create an external reference linked to a DataSheet in another workbook.
Basically I have all my information and data in 2 worksheets based on a 'Data Reference' worksheet in the same workbook. This contains simply everything from named ranges used for Data Validation to...
I am trying to do something here.
I searched the internet and found this how to article. http://www.ehow.com/how_2105843_link-data-another-spreadsheet-excel.html.
This is half-way what I'm trying to do.
What I am REALLY trying to do is... (Referreing to the example in this article...)...