IntroductionContact UsCopyrightOn-line Help LibraryWhich file formats are supportedComparison StrategyxlCompare CommandsFile | OpenFile | Recent ComparisonsCompare | BooksCompare | SheetsCompare | ModulesCompare | OptionsView | LayoutView | Ignore FormattingTools | RecalculatexlCompare ActivationHow to activate xlCompare on the another PC?How to restore xlCompare on my PC?License detailsHow to remove trial limits?General Questions Extended View modeDisplay differences in Extended ViewFilter differencesMerge data from two worksheetsUpdate records on the worksheetDuplicate RemoverGet duplicates between 2 listsExtract Unique RecordsCommand Line modeSave changes in the workbookSave comparison report on diskWorking with TXT and CSV filesFilter data you want to compareIgnore error valuesTrace Formula CalculationsMinimize Difference BrowserSynchronize rows and columnsMark differences (changed cells) with colorDatabase ComparisonCompare worksheets As DatabaseManage Primary KeysHide Equal ModulesFilter cells on the worksheetJoin 2 lists in ExcelFind duplicates in ExcelRemove duplicates in ExcelRemove empty rows on the worksheetBulk Merge operationsBulk Undo operationHighlight only results you needVersion ControlUse xlCompare with SVN to resolve conflictsCompare Visual Basic ProjectsCompare controls on the VB FormsMerge controls on the formsMerge contents of the VBA ModulesI've found a problemSending bugreports to Spreadsheet Tools
Bulk Merge commands
Lets imagine the usual common situation - you are working with big amount of "database" lists or processing price lists or accounting statements. You have a lot of changes on the worksheet, and they should be quickly merged into another file. If you will do it item-by-item, you will spend all day. Bulk Merge commands is what you need.
Bulk Merge commands was created to automate merge operations. You select branch in the Difference Explorer you want to merge into another worksheet. Apply merge operation and all modification of the every item is applied to another worksheet.
Data is merged in single click!
This example describes Bulk Merge commands in detail:
We've compared Cash Flow statement and want to merge all changes from the left worksheet into the right one.
We select Sheet1 - Sheet2 node in the Difference Explorer. It represents all changes found between worksheets.
Bulk merge commands are in the right click menu: RCM | Bulk Merge | .... You see them on the image above.
After this command is applied xlCompare looks like on the image below:
All items on the left worksheet are checked. This means that modification is applied to the another book. I.e. conflict is resolved.
Bulk merge commands are present not only in the Right Click menu. You can find them on the toolbar also.
Bulk merge commands on the toolbar in the Difference Explorer
IMPORTANT: Bulk merge commands are applicable not only to the worksheet data. You can use them to merge VBA Modules and Forms also!