Forum Discussion

PeterMarcellas's avatar
PeterMarcellas
Copper Contributor
Jan 11, 2024

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 workbook

 

I would like to reference the workbook files however each day they are download the date and time in the file name is different.

 

My attempt - 

 

='[item-sales-summary *.csv]item-sales*'!A1

Since the date after the file name is the only thing that changes  I was wondering if the * would work, It appears as though it does not. 

 

Any tips, tricks, or ideas?

Thanks!

 

 

excel
Formulas and Functions
training

1 Reply

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Jan 12, 2024
    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.

Resources