Step 5: Pick the columns to add to your main table If you have a lot of columns in your table, the counter at the bottom of the add-in window will help you keep track of how many you select. Pressing Unselect All will remove selection from all columns.If you ticked the Main table has headers and/or Lookup table has headers checkboxes, only columns with corresponding headers will be selected. Click Auto Select to get all the columns selected as matching.This will instruct the Merge Tables Wizard to distinguish between uppercase and lowercase letters in the values it compares. If text case in the key columns is important to you, tick off the Case-sensitive matching checkbox at the top.In this case, the contents of the 1st row will be displayed to help you match the right records. If your tables do not have headers, clear these boxes. If your tables have header rows, select the Main table has headers and/or Lookup table has headers checkboxes.If there is no match, please select one in the drop-down list of Lookup table columns. Once chosen, the add-in will automatically pick a column with a matching header in a lookup table if there is one.
Tick the checkboxes next to the columns you need to compare. Here you can see a table with a list of all the columns you have in your main sheet.
#LINK DATA BETWEEN WORKSHEETS IN EXCEL FOR MAC UPDATE#
Please note that the values in these columns are only compared you will be able to select the columns to update on the next step.
Key columns are the important ones that let you identify the same records in your sheets, for example, IDs or the combination of First and Last names. Your tables may have several columns in common. You can edit the range by clicking the Select range icon or simply using your mouse cursor to select it in your table.
0 kommentar(er)
