Data controlling Excel

[Korsholm]

have two different basis information placed in two
different library. When I want to display the result in
the mastersheet I just change one cell in the mastersheet
and I will get the correct data

Ind the master sheet the following reference is typed

=+'C:\Production\ver_1\[prodktion.xls]Product1`!$D$16

I like to change the 'ver_1' to 'ver_2' buy typing it into
a cell in the master sheet

I have succeeded within a spreadsheet using CONCATENATE ()
and Indirect ()

But when I try to use it on libraries I do not succeed


can some body help me

 

[Anon]

have two different basis information placed in two
different library. When I want to display the result in
the mastersheet I just change one cell in the mastersheet
and I will get the correct data

Ind the master sheet the following reference is typed

=+'C:\Production\ver_1\[prodktion.xls]Product1`!$D$16

I like to change the 'ver_1' to 'ver_2' buy typing it into
a cell in the master sheet

I have succeeded within a spreadsheet using CONCATENATE ()
and Indirect ()

But when I try to use it on libraries I do not succeed


can some body help me

I think INDIRECT will not work to other workbooks unless they are open.
I suggest putting two simple references (like the one you quote above - note
that you do not need the + sign) in two cells, so that you pull data from
both libraries. Then make the selection between them (maybe using a formula)
within the mastersheet.

 

[Korsholm]

God way to do it - it just damands some planing, when you
do not know the amount of cersions - thanks

-----Original Message-----

have two different basis information placed in two
different library. When I want to display the result in
the mastersheet I just change one cell in the mastersheet
and I will get the correct data

Ind the master sheet the following reference is typed

=+'C:\Production\ver_1\[prodktion.xls]Product1`!$D$16

I like to change the 'ver_1' to 'ver_2' buy typing it into
a cell in the master sheet

I have succeeded within a spreadsheet using CONCATENATE ()
and Indirect ()

But when I try to use it on libraries I do not succeed


can some body help me

I think INDIRECT will not work to other workbooks unless they are open.
I suggest putting two simple references (like the one you quote above - note
that you do not need the + sign) in two cells, so that you pull data from
both libraries. Then make the selection between them (maybe using a formula)
within the mastersheet.


.