Methods of Entering Data into the Worksheet

 
There are two ways to populate information in the worksheet:
 
a)     Import, type or paste data directly into the cells provided.  No validation is performed until you run the upload program or open the ‘Transaction Details’ form.
 
b)     Use the ‘Batch Header Values’ form to enter the batch header details and then use the ‘Transaction Details’ form to enter detailed information about the transaction.   Data is validated and lists of values are available. 
To enter data in this way, first position your cursor on the row you wish to contain the transaction data.  Then double-click in one of the cells or alternatively click on the ribbon icon. 
 
Refer to section: