This option provides a form where multiple search criteria can be used for data matching.
To access the form, position the cursor somewhere in the sheet below row 10. The data will be downloaded at this point, pushing all existing rows downwards.
Click the ‘Download’ icon and select the ‘Download Form’ option as shown below:
This opens the ‘Download Form’ as follows:
Project Funding Criteria tab:
Enter criteria into one or more of the fields on the Download Form, to select the required information. You may use the wildcard character ‘%’ to increase the search capacity.
Agreement Number – You can enter the wild card % then select the button to display all agreements. Select a value from the list of values provided.
To restrict your list of values, enter a value surrounded by the wild card and then click the button to display all agreements which meet your criteria.
Wild Card – Another option is to enter a value surrounded by the wild card and then select the ‘Download’ Button. This will return all agreements which have the entered criteria as part of the agreement number.
Click the ‘Download’ button on the form and the information that meets the criteria will be extracted into the worksheet.
Click ‘Clear’ to clear all values in the form, or ‘Cancel’ to close the form.
button to display all agreements. Select a value from the list of values provided.