excel

Using parameters to create dynamic file paths in Excel queries

Parameters are an incredibly powerful tool when constructing queries in Microsoft Excel. And if your source data changes frequently, parameters can come in extremely handy to change multiple file names/paths hurry. For example, I had queries set up to pull data from about 30 spreadsheets from our finance department. Every month, they ran new reports […]

Read More