Thread: consolidation sum where ending tab value is changeable
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Seaq Seaq is offline
external usenet poster
  
Posts: 9
Default consolidation sum where ending tab value is changeable
Hi, I am trying to figure out how to substitute the ending tab value by the
value in another cell

i.e. =SUM('04:03'!C46) , where tab name "03" need to change according to
selection.

please help! Thanks in advance
Reply With QuoteReply With Quote