Good day,
I have a workbook containing multiple sheets and a 'Summary' sheet. I have a column in the Summary sheet named 'Balance as Per Schedule' and I want to sum the amounts in the 'Total' columns on each sheet by using the ID No as the criteria.
Basically there is a column for 'Total' on each sheet and ID No on each of those sheets as well. I want the total of those Totals on the Summary Sheet for every ID number.
The ID Numbers are in column B from row 4 in each sheet. The "Balance as Per Schedule' column is column Q beginning row 4 as well.
The other sheets are named 'Credit Card', 'Travel Advance', etc, for example:
'Credit Card'
<tbody>
</tbody>There are many columns between ID No. and Total
'Travel Advance'
<tbody>
</tbody>
The Summary Sheet will look like this:
<tbody>
</tbody>
Thank you!
I have a workbook containing multiple sheets and a 'Summary' sheet. I have a column in the Summary sheet named 'Balance as Per Schedule' and I want to sum the amounts in the 'Total' columns on each sheet by using the ID No as the criteria.
Basically there is a column for 'Total' on each sheet and ID No on each of those sheets as well. I want the total of those Totals on the Summary Sheet for every ID number.
The ID Numbers are in column B from row 4 in each sheet. The "Balance as Per Schedule' column is column Q beginning row 4 as well.
The other sheets are named 'Credit Card', 'Travel Advance', etc, for example:
'Credit Card'
Name | ID No. | Total |
John | 1001 | 250.00 |
Luke | 1002 | 460.00 |
<tbody>
</tbody>
'Travel Advance'
Name | ID No. | Total |
John | 1001 | 500.00 |
Luke | 1002 | 700.00 |
<tbody>
</tbody>
The Summary Sheet will look like this:
Name | ID No. | B/F | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Total | Balance as Per Schedule | Variance |
John | 1001 | 750.00 | |||||||||||||||
Luke | 1002 | 1160.00 |
<tbody>
</tbody>
Thank you!