Forum Discussion
Use of wildcards when referencing a separate workbook
I have a inventory processing database that is dependent on my POS latest sales report as well as item catalogue Currently I am copying and pasting the data from those workbooks to my processing ...
You're going to need INDIRECT to tell Excel the text is a workbook reference. Although, I can't recommend INDIRECT because it's volatile and requires the linked workbook to be open to calculate. Another approach might be to query the workbook with PowerQuery and go from there.