filename references

F

f_ringberg

i have two excel files. test.xls contains some information i want to
have uppdated to fredrik.xls

this works in test.xls
='U:\tmp\[fredrik.xls]Blad1'!B10

but instead i want to change the filename [fredrik.xls] with a cellname
in test.xls

if i have in test.xls A1 the text-string fredrik.xls who can i then add
A1 in the filename:

this works not but this is the solution i want.
='U:\tmp\[A1]Blad1'!B10

A1 should be replaced with something more between [ ]
 
F

f_ringberg

i mean i have in A1: test

this i want to have inserted in:
='U:\tmp\[A1.xls]Blad1'!B10

How should A1 be wroted??
 
A

Ardus Petus

I fear this is not possible, because you have tu use the INDIRECT function
which does not work with external Workbook reference.

HTH
 
F

f_ringberg

Is it possible to instead copy the cell/row with the value of
='U:\tmp\[fredrik.xls]Blad1'!B10

to a new row and keep exact the same??

If I could do this a can only on the copied row change the filename
manually BUT i must keep the B10 reference. When i copy the cell and
inserts it on another row it always add numbers to B10:
='U:\tmp\[fredrik.xls]Blad1'!B12

This has not to happen. I don't find any way in excel to copy a
cell/row and keep exactly the same to the new row??
 
D

Dave Peterson

You could use this formula:
='U:\tmp\[fredrik.xls]Blad1'!$B$10

or you could just use a formula that points back at the first cell with that
formula:
=A1



Is it possible to instead copy the cell/row with the value of
='U:\tmp\[fredrik.xls]Blad1'!B10

to a new row and keep exact the same??

If I could do this a can only on the copied row change the filename
manually BUT i must keep the B10 reference. When i copy the cell and
inserts it on another row it always add numbers to B10:
='U:\tmp\[fredrik.xls]Blad1'!B12

This has not to happen. I don't find any way in excel to copy a
cell/row and keep exactly the same to the new row??
Click to expand...
 
Top