In the following example, a Materials Requisition Form needs to be updated and printed for a list of sales orders that need to be produced in a job order system.
The Order List includes the data needed for cells C4 and C5 in the Materials Requisition Form as well as the order number in cell C3.
Figure 3 Sub Macro1() Dim PageCount As Integer For PageCount = 5 To Range("H22")+4 A loop counter to track the number of pages printed Range("C3") = Cells(PageCount, 6) Using the cell "row/column" format and the PageCount variable, this updates the Materials Requisition Form from the data in the order list.
The documents related to that request might include the materials requisition, the purchase order, the warehouse receipts journal, the voucher payable, and the cancelled check.
In an end-to-beginning analysis, the same items would be reviewed, except in reverse order starting with the general ledger and working back to the materials requisition. The beginning-to-end analysis is necessary to determine the propriety of the transaction and to ensure that the items have been authorized and properly recorded.