The Wizard provides the user with the ability to enter one or multiple criteria directly into the worksheet and download the Asset(s) that meets the criteria.
This download method is currently limited to entering data into the following columns: Book, Asset Number, Serial Number, Tag Number, Invoice Number, Queue and Category. Of course this can be expanded, so please ask if you require additional columns in the selection criteria.
Note– When using the ‘Download using sheet data’ option in the Wizard, the ‘Default Values’ row (Row 10) is not used.
Enter the criteria for the download directly into the worksheet.
Select the rows to download (make sure that only one cell is selected for each row) and click the ‘Download’ icon and select ‘Download using sheet data’, as shown below:
The results of the download are returned directly to the highlighted range. In our example, the second row for Asset 100091 returned a row for each of the three books the asset belongs against.
