Posts by uzan123

    Can anyone solve this below problem


    I have two worksheets as follow:


    1. FGSummary_PossibleToRes_20140121.xlsx
    2. FGSummary.xlsx



    In sheet1 of worksheet FGSummary.xlsx, I need value of cell J1 of sheetname(NResSoak) of worksheet FGSummary_PossibleToRes_20140121.Xlsx Full Path:='\\192.168.9913\SSRS_DailySummaryReport\[FGSummary_PossibleToRes_20140121.xlsx]NResSoak'!$J$1



    Please note that the red highligted is date in the worksheet name (Format: YYYYMMDD) and it changes daily.


    I tried below formula but it doesn't work


    =INDIRECT(CONCATENATE("'\\192.168.9913\SSRS_DailySummaryReport\[FGSummary_PossibleToRes_",C1,".xlsx]NResSoak'!$J$1"))


    C1 = today's date (Format: YYYYMMDD) which is 20140121

    I appreciate if you could solve this problem


    thank you!