Hello
I'm looking to make this:
='C:\Users\bprest1\Backup\Documents\Inventory\Master Region Stale\2017\[Master Region Stale Report 9-4-17.xlsx]Burris, Michael'!$E1
Use a variable cell reference for the DATE.
='C:\Users\bprest1\Backup\Documents\Inventory\Master Region Stale\2017\[Master...