INDEX/MATCH Question
I am having issues with having to copy and paste particular cells from 6 separate excel files into my master excel sheet. I’ve used INDEX/MATCH in the past to extrapolate data within multiple sheets in the same file. Now, I have 6 separate excel files I am opening, copy & paste to my master sheet, and then closing out. Is there some type of advanced INDEX/ MATCH function that can streamline this process to make this more efficient? I'm trying to reduce the amount of time I spend having to copy and paste.
Thanks in advance!
|