Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
merging data from 1 excel file, into a master excel file
I have 2 spreadsheets - a master spreadsheet and sheet #2. Sheet #2 contains
all of the information from the master (with the same exact columns), plus new rows that are inserted throughout. The first column of data uniquely identifies each row. Most of the rows are identical in both, with some tweaks to the master. Therefore, I do not want any cells in the pre-existing rows to be overwritten in the master. I'd like to merge in just the new rows from sheet #2 into the master, and leave everything that is already in the master (and has been tweaked), as is. How do I do that? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merging 2 workbooks??? | Excel Discussion (Misc queries) | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
no data in excel file | Excel Discussion (Misc queries) | |||
Getting data from another excel file | Excel Discussion (Misc queries) |