Technical Support

Update records on the worksheet

Spreadsheet Tools welcomes your inquiries. You can contact us by e-mail support@SpreadsheetTools.com, or fill the Technical Request form on the Spreadsheet Tools website.

We suggest you to review the topics below. Possible you'll find answer to your questions about xlCompare here.

We've created a F.A.Q section on our website. It contains answers to the most common questions we receive. In this section you'll also find a useful information for you. Go to the F.A.Q. topic

xlCompare: How to update records on the worksheet

Update command is applicable when you need to update all records from your list with values from another list, without adding new records. For example, you've received new prices which should be added to your existing list.

Use the drop-down arrow on the Compare button to select the Update command:

xlCompare commands

When you select Update command, xlCompare does the following:

  • Find equal rows and columns on both worksheets
  • Update existing records - cells in the equal rows and columns
  • Update cells are marked with color
  • New records on the right worksheet are not taken into account/li>

You don't get comparison results in this case. This command does all work itself and gives you result of update operation on the left sheet.

So, data from the right book(worksheet) is merged into the data in the left book(worksheet).

See Also: