Understanding external references in Microsoft Excel?
August 8, 2006 7:05 AM Subscribe
It's very clear in Microsoft Excel how to calculate formulas using external references, but what isn't clear is how, in several worksheets, to have the same data in certain columns. How do I do this?
posted by arimathea to Technology (9 answers total) 1 user marked this as a favorite
Say I have an Excel file with multiple workbooks - BOOKONE, BOOKTWO, BOOKTHREE. Now, in each of these workbooks or worksheets, I have data that looks like, well, a price list, with a textual description, part number, price, etc. If in BOOKTWO I want to reference the data in BOOKONE - multiple cells at once - how can I do that? The range operator, e.g. ='BOOKONE'!A1:A15, doesn't work correctly, reporting #VALUE.