Thread: Indexing a formula from Sheet to Sheet
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default Indexing a formula from Sheet to Sheet
Starting on sheet "Wk02"
enter at B1
=INDIRECT("Wk"&TEXT(RIGHT(CELL("filename",A1),2)-1,"00")&"!B1")+A1

Reply With QuoteReply With Quote