Version: Office 2016
I'm trying to create a spreadsheet at work that can be used by anyone for our processes. There's a CSV file that's downloaded weekly, and will replace last week's CSV file. The name of the file remains the same.
What I'm looking for is when you open workbook X, the dropdown in a column references the weekly CSV file. I'm not looking for it to import the data and put it on another sheet in workbook X. This way whenever that workbook is opened, it has all the latest information.
For reference, the CSV has 2800 rows of data, and is growing. We get the CSV file from software, and we don't have control over how we export it.
I'm trying to create a spreadsheet at work that can be used by anyone for our processes. There's a CSV file that's downloaded weekly, and will replace last week's CSV file. The name of the file remains the same.
What I'm looking for is when you open workbook X, the dropdown in a column references the weekly CSV file. I'm not looking for it to import the data and put it on another sheet in workbook X. This way whenever that workbook is opened, it has all the latest information.
For reference, the CSV has 2800 rows of data, and is growing. We get the CSV file from software, and we don't have control over how we export it.