|
|
|
|
#1
02-13-2017, 12:51 PM
|
|||
|
|||
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! 
|
|
|
|
Similar Threads
|
||||
| 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 |
 Question about Index match formula to copy all of cells in row
|
dmcg9760 | Excel | 1 | 11-08-2015 01:41 AM |
| Index match vba | grexcelman | Excel | 0 | 03-05-2015 10:55 PM |
Windows 8 
Office 2010 64bit
Hybrid Mode