Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-24-2019, 03:06 PM
honkin honkin is offline Import Data From One File To Another Mac OS X Import Data From One File To Another Office 2011 for Mac
Novice
Import Data From One File To Another
 
Join Date: Sep 2017
Posts: 2
honkin is on a distinguished road
Question Import Data From One File To Another

hi

I am having some difficulty importing data from one file to another and wondered if I might seek some assistance.

The code I have been using for ages allows me to import data from various files into a single central file without issue, but I am now trying to bring data into a different file and it is simply not working.

Here is the code that works to bring data in



Code:
=IF(ISERROR(MATCH(1,INDEX((INT('VDW-November-2017.csv'!A$2:A$10000)=A3)*('VDW-November-2017.csv'!J$2:J$10000=D3),),0)),"",INDEX('VDW-November-2017.csv'!P$2:P$10000,MATCH(1,INDEX((INT('VDW-November-2017.csv'!A$2:A$10000)=A3)*('VDW-November-2017.csv'!J$2:J$10000=D3),),0)))
Depending on the location of the data I require, file name, column and row references change, but essentially it is the same code. It has worked for ages into the same single central file.

So what would be causing the same code not to be working at all when I try to import into a different file? No matter what I do, I cannot get any data at all to import; the result is simply a blank cell

Any help gladly accepted

Regards
Reply With Quote
  #2  
Old 07-27-2019, 01:44 AM
Lugh's Avatar
Lugh Lugh is offline Import Data From One File To Another Windows 10 Import Data From One File To Another Office 2016
Competent Performer
 
Join Date: May 2019
Location: USA
Posts: 137
Lugh is on a distinguished road
Default

I got dizzy counting, but does the number of closing ')' match the opening '(' ?
Reply With Quote
Reply

Tags
import data from excel

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to import multiple text file data into word mizankabir Word VBA 7 09-15-2023 10:27 PM
Import Data From One File To Another macro, data import from the ONLY text file in current folder ue418 Excel Programming 5 10-28-2017 12:52 PM
Import some data to Word before run KariiO Word 2 04-02-2016 04:02 PM
Import Data From One File To Another Import data from CSV to table gebobs Excel Programming 4 10-20-2014 04:40 PM
import .mht file data to powerpoint Rubini MJ PowerPoint 0 07-24-2013 10:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:57 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