Hey everyone,
Need help
I have the following Dynamic reference on sheet "Ranges"
=IF(TDCustomerName="","",INDIRECT(CONCATENATE("'[",$K$387,".xlsm]","sheet 1","'","!E3")))
This refers to another workbook with a range of customer data. The above code, obviously refers to an ever changing file...