Hello Friends,
I am using this formula to get some contents from a closed workbook
=SUMPRODUCT('C:\OneDrive\Internal Sheets - Excel Files\Lomotex\[510.xlsm]327744'!$F$58)
I want the formula to pick the file name from lets say cell A1 and sheet name from cell A2
Any help would be appreciated
Regards,
Humayun
I am using this formula to get some contents from a closed workbook
=SUMPRODUCT('C:\OneDrive\Internal Sheets - Excel Files\Lomotex\[510.xlsm]327744'!$F$58)
I want the formula to pick the file name from lets say cell A1 and sheet name from cell A2
Any help would be appreciated
Regards,
Humayun