change name

[DBozMen]

Hi all,

I'm kinda new at this but my boss wants me to find something out. This
is the situation:

You have file_A and file_B

Now we want that if you change something in file_B, it will also
change in file_A. I got there for a code: ='[file_b.xls]Blad1'!B4.

But the name of file_B changes ever week so I need to know if there is
a possibility to change a name for example to file_C automatically.

HINT: /me = n00b

I hope some1 can help me.

GreetzZ,

DBozMen

 

[Bernie Deitrick]

DBozMan,

For a n00b, the easiest way is to select all your cells (use the button
above and to the left of A1) then use Ctrl-H and replace file_B with file_C.

HTH,
Bernie
MS Excel MVP