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
|