Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Use of wildcards when referencing a separate workbook

Copper Contributor

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!

 

 

1 Reply
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.