Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-02-2017, 04:01 PM
abs004 abs004 is offline Merging Multiple Files by Name, Date Windows 10 Merging Multiple Files by Name, Date Office 2016
Novice
Merging Multiple Files by Name, Date
 
Join Date: Mar 2017
Posts: 1
abs004 is on a distinguished road
Default Merging Multiple Files by Name, Date


Hi, I am a moderately competent Excel user. I am looking for help with a way to merge numerous files by name and date without creating duplicate rows. For example, I have a file that tells me Susie's (and 1000s of others') demographic information, another that tells me when and where Susie ate lunch for 5 months, another that says how much gas she spent get to lunch, mileage, make of her car, and another that says all the times she was late or on time to work. I want to merge all of these files into one large worksheet, with Susie having a single row, with each lunch day sorted by date, with info about lunch, mileage, and being on time to work for that specific day. So, in theory, it would say Susie, 1/1/2015, Jimmy John's, 48 miles, 1 hour late to work. Then, 1/2/2015, McDonald's, 2 miles, on time, etc. So, how can I do this using formulas or programming while not copying over duplicate rows, as each row says Susie's name and the date. Any help you could offer would be wonderful, as I have only been able to merge the files as a whole, rather than by specific columns by date. Thank you so much!
Reply With Quote
  #2  
Old 03-02-2017, 04:21 PM
jeffreybrown jeffreybrown is offline Merging Multiple Files by Name, Date Windows Vista Merging Multiple Files by Name, Date Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Cross-posted at: http://www.excelforum.com/excel-gene...name-date.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Letter date changes when merging with Excel - not the format, the actual date! Smallweed Mail Merge 1 02-07-2014 06:00 PM
Merging pst files and moving to NAS drive riteoh Outlook 0 10-02-2012 05:20 AM
Merging Multiple Files by Name, Date convert multiple csv files to multiple excel files mit Excel 1 06-14-2011 10:15 AM
Merging Multiple Files by Name, Date Merging multiple .txt's Bartestokles Word 5 12-29-2010 01:42 PM
Merging Multiple Word files into One Stattovic Word 0 01-06-2010 07:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:57 AM.


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