maikeyjohn
Board Regular
- Joined
- Oct 7, 2013
- Messages
- 66
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.