copy the content variable in the formula

[maikeyjohn]

	A	B
1	AAPL	MSFT
2	='C:\Documents and Settings\SASTC\My Documents\Stock Data\[AAPL.csv]AAPL'!E2	='C:\Documents and Settings\SASTC\My Documents\Stock Data\[MSFT.csv]MSFT'!E2

<tbody>
</tbody>

how should i COPY automatically "XYL" written as in formula (XYL.csv and XYL') comprehending with the top bar?

Tried "&C1&" but it`s not working.

 

[wigi]

I'm sorry but I don't understand it.
Where do you have XYL in your table?

 

[maikeyjohn]

It would be in c1 and c2

 

[maikeyjohn]

C

1 XYL

2 ='C:\Documents and Settings\SASTC\My Documents\Stock Data\["&C1&".csv]"&C1&"'!E2

 

[wigi]

So row 2 should get the data from a different spreadsheet, based on input in row 1?

 

[maikeyjohn]

Yes !!!

Its a csv file data value i want to fetch it

the formula typed fetches the value from aapl.csv e2 data value

i want to do it for "all" the stocks value

 

[maikeyjohn]

gives me error #REF

 

[wigi]

Are the files opened or closed?

 

[maikeyjohn]

opened

 

[maikeyjohn]

before that i go to DATA > Edit Links > Check Status > Open Source