Simple? Reference Question

J

j

Can I reference a value in a spreadsheet that is not open?

I have 2 spreadsheets, 1 for the totals- and 1 for the values. I want the
total spreadsheet to update when the value spreadsheet is updated. Do I need
a macro to open the spreadsheet, grab the values and pull them into the total
spreadsheet, and close the values?

Thanks,
Jesse
 
D

Dave O

No need for a macro- just open both files at once. Let's call them
Source.xls and Target.xls: Target is the file your working on, and
Source is the one that holds the data to be referenced. With both
files open, start the formula in Target.xls, and then when you need to
reference the data in Source.xls, just click on the cell in Source.xls.
The formula will look a little unusual, just fyi.

The next time you open Target.xls (after you reference the cell in
Source.xls), you'll get a message asking if you want to update those
values.

If I can suggest, read up on this topic in Help- there are a number of
pitfalls involved if you rename files, for instance.
 
Top