excel formula sheet name

  1. R

    Excel Formula Help needed on Sheet name retrival

    I have an existing formula in a cell as : =[Sample.xls]OC1!$F$1 You will understand that it is taking the value of the Cell F1 of Sheet OC1 of the excel workbook Sample.xls <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I do not want to hardcode the...

Some videos you may like

This Week's Hot Topics