Thread: [Solved] Merging Two Spreadsheets
View Single Post
 
Old 03-23-2015, 01:05 PM
buechler66 buechler66 is offline Windows 7 64bit Office 2013
Novice
 
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