![]() |
#1
|
|||
|
|||
![]()
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! |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Index Match - Urgent Help | chappers | Excel | 2 | 11-02-2016 03:17 AM |
Excel - Index and Match Function ,First Second and Third Match | paulzy95 | Excel | 10 | 09-29-2016 10:46 PM |
Index and Match functions | aman.chauhan | Excel | 1 | 06-18-2016 02:09 AM |
![]() |
dmcg9760 | Excel | 1 | 11-08-2015 01:41 AM |
Index match vba | grexcelman | Excel | 0 | 03-05-2015 10:55 PM |