#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
Can't open spreadsheets | kaygeea | Excel | 7 | 10-05-2011 08:00 AM |
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 |