If i have a worksheet that contains Receipts and Payment Journal for a small business and i have other worksheets for the individual accounts represented in the Journal, how can i get the individual accounts to be updated as entries are made in the Receipts and Payment Journal?
If you enter an identifier related to the Account for each payment or receipt then this can be used to update the sheet with the individual account. This can be accomplished with conditional formulas such as SUMIF, COUNTIF etc.
