View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rachel Rachel is offline
external usenet poster
 
Posts: 113
Default Use a calculated value as a worksheet reference

I want to use the value of the MONTH function within a formula to refer to a
sheet in another workbook eg ='May'! where the reference May comes from the
result of =MONTH(Serial_Number)

Any ideas please

--
Many Thanks
Rachel