Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-09-2016, 02:35 PM
KingoftheKassel KingoftheKassel is offline Importing Data from seperate closed excel file Windows 7 64bit Importing Data from seperate closed excel file Office 2010 64bit
Novice
Importing Data from seperate closed excel file
 
Join Date: Jul 2015
Posts: 5
KingoftheKassel is on a distinguished road
Default Importing Data from seperate closed excel file

Hey guys, so I have a main file that I will be needing to import information to. I get new secondary files regularly. These new files contain new information about already existing ID numbers. Both files have an ID number that I need to match up. A short example is given below, hopefully this will clarify:



Workbook A:

ID__________ Detail A____ Detail B ____Detail C
1702_012 ____blah___ ____blah_______ blah
1702_013 _____--- _______random _____ blah
1702_014 _____..._______ &234_______ Kasaw
1710_147 _____hmm____- fki-_________ eev
1710_148 _____hey ______sup _________fam
1726_034 _____??:______ sdf___________ sij



Workbook B:

ID ________________________Detail F_________ Detail G ______Detail H
07-0002_012_29012_AW ______aqdq ____________239dfe______ 56456
07-0002_013_99023_TE ______wewe ____________1230_________ Jet
07-0002_014_57489_PO ______fuel2122221222222 cant_________ melt
08-0010_147_28004_DC ______deez____________ nuts__________ ha
08-0010_148_45367_MG ______got____________ heem__________ thx
50-0026_034_95184_LZ ______4da_____________ help___________ <3



Workbook A would be my main workbook. I would be getting a new "workbook b" regularly. I want to add the details from workbook B to workbook A using the IDs as the commonality. Thank you so much in advance for your help, guys and girls!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing Data from seperate closed excel file importing a .CSV Contacts file from Excel to Outlook 2013, mahfoudhhi Outlook 9 09-21-2014 05:25 AM
Importing Data from seperate closed excel file Importing\convert a bin file to Excel shabbaranks Excel Programming 1 07-10-2014 12:18 AM
Importing Data from seperate closed excel file Importing/Exporting data using Excel and some specific rules stagg201 Excel 1 03-27-2014 08:58 PM
Importing Data from seperate closed excel file Importing data from excel using a macro soma104 Word 1 04-14-2011 05:10 PM
Can I do this? sorting data in seperate columns shumonsaha Excel 0 07-04-2010 03:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:47 PM.


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