D
Duncs
I have an Excel 2003 spreadsheet that had 12 tabs on it, one for each
member of the team. On this tab, they record details of specific
calls that they have taken, including the date that the call was taken
on.
What I want to do, is include a summary tab that will show for all
tabs, the date and the summation of all financial values from the
tabs.
So, for example, if the first three tabs show the following
information:
Tab Date Written Off
Original New
1 10/10/2008 250.00
6.00 5.00
1 10/10/2008 175.00
25.00 17.00
1 12/10/2008
6.00 3.05
2 10/10/2008
27.00 15.00
2 15/10/2008 75.00
3 12/10/2008
6.00 5.00
3 12/10/2008
12.00 7.50
3 13/10/2008 125.00
12.00 3.05
I want the front summary tab to show:
Date Total Written Off
Original Total New Total
10/10/2008 425.00
59.00 37.00
12/10/2008 0.00
24.00 15.55
13/10/2008 125.00
12.00 3.05
15/10/2008 75.00
0.00 0.00
Is this possible?
TIA
Duncs
member of the team. On this tab, they record details of specific
calls that they have taken, including the date that the call was taken
on.
What I want to do, is include a summary tab that will show for all
tabs, the date and the summation of all financial values from the
tabs.
So, for example, if the first three tabs show the following
information:
Tab Date Written Off
Original New
1 10/10/2008 250.00
6.00 5.00
1 10/10/2008 175.00
25.00 17.00
1 12/10/2008
6.00 3.05
2 10/10/2008
27.00 15.00
2 15/10/2008 75.00
3 12/10/2008
6.00 5.00
3 12/10/2008
12.00 7.50
3 13/10/2008 125.00
12.00 3.05
I want the front summary tab to show:
Date Total Written Off
Original Total New Total
10/10/2008 425.00
59.00 37.00
12/10/2008 0.00
24.00 15.55
13/10/2008 125.00
12.00 3.05
15/10/2008 75.00
0.00 0.00
Is this possible?
TIA
Duncs