Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-23-2015, 01:05 PM
buechler66 buechler66 is offline Merging Two Spreadsheets Windows 7 64bit Merging Two Spreadsheets Office 2013
Novice
Merging Two Spreadsheets
 
Join Date: Mar 2015
Posts: 1
buechler66 is on a distinguished road
Default Merging Two Spreadsheets

I have an 'old' and a 'new' version of my spreadsheet. There are two completely separate xls files with similar content, but not all the columns match anymore because the new version was modified slightly.

Filenames:
'old' is named 'IV VersionOne Export 20150228.xlsm'
'new' is named 'IV VersionOne Export 20150320.xlsm'

Both spreadsheets have a column named 'ID' that is a unique value. The 'old' version contains a column named 'WBS' that was dropped from the 'new' version. I want to put it back on my 'new' spreadsheet where the 'ID' values are the same.

Is this possible? I have zero experience, but I'm willing to try to follow an example if someone has time to help me. Any help would be greatly appreciated.
Reply With Quote
  #2  
Old 03-25-2015, 11:57 AM
charlesdh charlesdh is offline Merging Two Spreadsheets Windows 7 32bit Merging Two Spreadsheets Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

Hi,

Can you not just copy the data from 1 workbook to the other?
If not can you provide an example? Detail what you need to move.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging Two Spreadsheets Joining two (or more) spreadsheets without use of a 'ghost' Richard121 Excel 2 02-16-2015 01:38 PM
HELP - comparing spreadsheets in excel 2010 ali212006 Excel 1 04-03-2014 04:04 AM
Merging Two Spreadsheets Can't open spreadsheets kaygeea Excel 7 10-05-2011 08:00 AM
Merging Two Spreadsheets Merging two spreadsheets BrazzellMarketing Excel 5 04-26-2011 01:51 PM
PWA, sharepoint links, and spreadsheets Rkramkowski Project 0 06-21-2006 01:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:46 PM.


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