merging data when the primary identifiers have changed order
Hello,
Suppose I have a spreadsheet with a list of names and organizations of people who have expressed interest in attending a certain workshop. I email the spreadsheet to a colleague, who follows-up and enters payment information onto the spreadsheet. In the process, she also eliminates the names of a few people who are no longer interested. She emails the sheet back to me. However, I have been continuing to add new names to the original. Is there a way to import the data from her version such that the information associated with a given name in her version is placed next to the same name in my version? (Without copying and pasting everything!) Thank you! |
merging data when the primary identifiers have changed order
Użytkownik "hipodamus" napisał w
wiadomości ... Hello, Suppose I have a spreadsheet with a list of names and organizations of people who have expressed interest in attending a certain workshop. I the spreadsheet to a colleague, who follows-up and enters payment information onto the spreadsheet. In the process, she also eliminates the names of a few people who are no longer interested. She emails the sheet back to me. However, I have been continuing to add new names to the original. Is there a way to import the data from her version such that the information associated with a given name in her version is placed next to the same name in my version? (Without copying and pasting everything!) Thank you! Try read (in Excel help) and use Tools-'Share Workbooks' and Tools-'Compare and Merge Workbooks' options. -- -- ============================== Janusz Pawlinka |
All times are GMT +1. The time now is 02:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com