Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merging 2 excel databases using unique identifiers | Excel Discussion (Misc queries) | |||
Combining data using a primary key | Excel Discussion (Misc queries) | |||
Coverting data from some columns to rows (but not the primary colu | Excel Discussion (Misc queries) | |||
Can the tab order be changed in Excell? | Excel Discussion (Misc queries) | |||
Can the tab order be changed in Excell? | Excel Discussion (Misc queries) |