Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-13-2017, 12:51 PM
huntld huntld is offline INDEX/MATCH Question Windows 8 INDEX/MATCH Question Office 2010 64bit
Novice
INDEX/MATCH Question
 
Join Date: Feb 2017
Posts: 1
huntld is on a distinguished road
Default 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!
Reply With Quote
Reply

Thread Tools
Display Modes


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
INDEX/MATCH Question 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft