I want to name an array to use in a formula with Index and Match.
Specifically speaking, I have 2 Hidden sheets. Every time the spreadsheet opens, the user is prompted to select 2 files. The contents of each file will be copied onto each of the Hidden Sheets. The problem is that I don't know...