1.Select a product type in the tree click on "Search". 2.Select the parts you like to update using the shift key and the mouse or the Ctrl key + A (to select all parts on the list). 3.Click "Copy" or press Ctrl + C. 4.Open an Excel file, click into the top left cell and press Ctrl + V to paste the parts. 5.You may now paste, export or enter data into the Excel file. Only the columns ROB, Reason for Change (in the column Checked Stock) and Last Change are considered. Please note that you can change the data in these three columns but you can not add new items or change other columns (e.g. the unit) like this. Please enter the date at "Last Change" in yyyy-mm-dd format (eg. 2017-11-22). 6.Copy all cells of the Excel file with Ctrl + A. 7.Open the respective list in Stock overview and click on "Paste". 8.A window pops up to confirm the data import. |