Uploading data from multiple worksheets

  1. In Excel, open a workbook with more than one worksheet, then navigate to the worksheet you want to upload first.
  2. Launch the Upload Wizard window.
  3. From the Map Columns tab, select the Infor Lawson form where the user intends to upload data.
    A tab group inside the Map fields section is displayed, with the first and only tab labelled with the name of the active worksheet.
  4. Map the Worksheet Columns to the required fields, and specify the values for the From Row and To Row fields.
  5. After mapping the first worksheet, navigate Excel to the next worksheet.
  6. On Upload Wizard, click Add new tab.
  7. Complete the worksheet setup.
    1. In Select worksheet to map, select the name of the next worksheet.
    2. In the Copy map from worksheet, select the name of the first worksheet to copy the mapping of the first worksheet.

      Optionally, you can select Don't copy and click OK if you choose to create the column map from scratch.

    If the number of columns in the two worksheets is not the same, then you cannot copy the column map from the first worksheet. You must create the column map from scratch.
  8. Optionally, on the second worksheet, you can add a new column map and delete the current column map by clicking the + and - buttons.
  9. After mapping the columns, navigate to the Upload tab and select from the Upload Options.
  10. Click Upload, and then select or clear which worksheets to upload on the prompt that is displayed.
  11. Click OK.