View Single Post
  #1   Report Post  
starfighter61
 
Posts: n/a
Default Read excel workbook

Hello

If i read from another workbook lets say
='L:\[Franvaro1Av43.xls]Sammandrag'!$H$10

And like to change the number 43 in the link to 44
is it possible to link that part of the link to a cell
like if cell b5 has the value 44
='L:\[Franvaro1Av{b5}.xls]Sammandrag'!$H$10