Hi all,
I am attempting to establish a workbook from a master file using an
"if" equation, so if A1 equals 1 then xyz data is pulled through.
However I need the workbook to auto update when changes to the master
file are made.
Is there another function that will complete the task?

Thanks

-----------------:)


--
Boethius1


------------------------------------------------------------------------
Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497
View this thread: http://www.excelforum.com/showthread...hreadid=509021

I understand this from your description:

You have a worksheet and want to type a formula that references a cell
in another workbook that is not loaded.

I would suggest you load that workbook. That makes it easier for you.

On your current sheet in A1 type:

=

then without doing something else select the master workbook under
"Window" from the main menu, select the sheet in that workbook, click
the cell you want to reference and hit enter.

Then you can close the master workbook. Excel will have modified your
formula to reflect the full path to the closed workbook.

The value in the cell of your current sheet will be updated s soon as
you open that workbook if you respond with "yes" to a question Excel
brings up (something like "the file contains a link to another
workbook, do you want to update your worksheet?).

This is what your formula will look like (only an example)

='C:\Dokumente und Einstellungen\Hans\Eigene
Dateien\[Book1.xls]Sheet1'!$B$3

Hans

thanks for reply, but i was looking for something to look at master
file, and if value matches consistently update rather than me manually
updating. if i use = to the file, that means i am telling it what to
pull through rather than using the IF function.
Does that make more sense?

----------------:)


--
Boethius1


------------------------------------------------------------------------
Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497
View this thread: http://www.excelforum.com/showthread...hreadid=509021