2 workbook, 3+3 sheet, network, 2 PC...

[lomajpure]

Hi! I would like to ask for help in the next (3 issues):
If two excel workbook. Both have 3 sheets (de, du, ej)
The goal would be to the first, if it is open, constantly refer to other cells. for example. the second file in du sheet to the contents of the first C1 and A1-du sheet a copy.
The second problem: the first time you open if you do not have the second File throw a warning window, there is not.
The third network, the two files in two different locations, and will be opened in two different machines.
Thanks in advance for your help!

sorry may english, but the google translate is not a Wizard

[arlu1201]

By what i understand, do you mean to say you are trying to copy data from 1 workbook to another? If the 2nd workbook is not open, a warning message to be given to the user. And the 2 workbooks are on 2 different computers in separate locations. Am i right?

[lomajpure]

Roughly Here's a concrete example, if you easier. : I have a business report generation. There are two departments (blister, delenser), and the two departments have their own workbook, and is separate from a master workbook. If you open the master, read it from.: BLISTER: A1 (etc.: 2000) into the MASTER C3. If you accidentally miss a blister or delenser file and open the MASTER, you can give a warning window. Yes, there is a network, all in different places, and all open files to other machines. Thank you