I would like to copy to new sheet by party wise and date wise up to last row. Can someone give a solution.
Excel 2007 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Tax Exempted | |||||||
2 | Tax Exempted | Date | Party Name | Bill No. | Amount | |||
3 | 22/06/2012 | Jackson company | 3 | 11,573.48 | 11,573.48 | |||
4 | 22/06/2012 | Primer associates | 5 | 41,316.07 | 41,316.07 | |||
5 | 14/08/2012 | Rital corporation | 11 | 9,155.67 | 9,155.67 | |||
6 | 10/09/2012 | Jackson company | 19 | 10,329.02 | 10,329.02 | |||
7 | 14/12/2012 | Primer associates | 53 | 13,871.43 | 13,871.43 | |||
8 | 05/12/2012 | Jerry and Bros | 46 | 4,444.50 | 4,444.50 | |||
9 | 08/12/2012 | Jimmy George | 48 | 4,444.50 | 4,444.50 | |||
10 | 20/12/2012 | Jerry Varghese | 59 | 5,555.63 | 5,555.63 | |||
11 | 24/12/2012 | Akash Associates | 61 | 7,081.49 | 7,081.49 | |||
12 | 27/12/2012 | Mithila Enter prises | 66 | 6,888.98 | 6,888.98 | |||
13 | 20/10/2012 | Akash Associates | 29 | 10,230.40 | 10,230.40 | |||
14 | Total = | 114,660.77 | 114,660.77 | |||||
15 | Tax 12.5% | |||||||
16 | Tax 12% | 22/06/2012 | Jerry and Bros | 2 | 40,468.13 | 40,468.13 | ||
17 | 22/06/2012 | Jimmy George | 6 | 252,237.84 | 252,237.84 | |||
18 | 15/07/2012 | Akash Associates | 8 | 19,583.40 | 19,583.40 | |||
19 | 14/08/2012 | Jackson company | 10 | 223,666.27 | 223,666.27 | |||
20 | 24/08/2012 | Primer associates | 14 | 69,814.81 | 69,814.81 | |||
21 | 10/09/2012 | Mithila Enterprises | 18 | 11,093.00 | 11,093.00 | |||
22 | 19/09/2012 | Primer associates | 21 | 15,421.77 | 15,421.77 | |||
23 | 25/09/2012 | Jimmy George | 22 | 23,103.32 | 23,103.32 | |||
24 | 14/12/2012 | Rital corporation | 54 | 10,705.46 | 10,705.46 | |||
25 | 24/12/2012 | Primer associates | 63 | 5,688.90 | 5,688.90 | |||
26 | Total = | 671,782.90 | 671,782.90 | |||||
27 | 5% | |||||||
28 | Date | Party Name | Bill No. | Amount | ||||
29 | 0.05 | 22/06/2012 | Jackson Company | 1 | 42,976.45 | 42,976.45 | ||
30 | 22/06/2012 | Akash Associates | 4 | 186,794.92 | 186,794.92 | |||
31 | 15/07/2012 | Jerry and Bros | 7 | 171,726.50 | 171,726.50 | |||
32 | 14/08/2012 | Jimmy George | 9 | 81,371.71 | 81,371.71 | |||
33 | 18/08/2012 | Jackson company | 12 | 281,825.39 | 281,825.39 | |||
34 | 24/08/2012 | Akash Associates | 13 | 25,867.86 | 25,867.86 | |||
35 | 01/09/2012 | Rital Corporation | 15 | 35,224.27 | 35,224.27 | |||
36 | 02/09/2012 | Primer associates | 16 | 16,501.02 | 16,501.02 | |||
37 | 05/09/2012 | Jimmy George | 17 | 16,320.76 | 16,320.76 | |||
38 | 10/09/2012 | Mithila Enter prises | 20 | 17,174.13 | 17,174.13 | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F3 | =E3 | |
F4 | =E4 | |
F5 | =E5 | |
F6 | =E6 | |
F7 | =E7 | |
F8 | =E8 | |
F9 | =E9 | |
F10 | =E10 | |
F11 | =E11 | |
F12 | =E12 | |
F13 | =E13 | |
F14 | =SUM(F3:F12) | |
F16 | =E16 | |
F17 | =E17 | |
F18 | =E18 | |
F19 | =E19 | |
F20 | =E20 | |
F21 | =E21 | |
F22 | =E22 | |
F23 | =E23 | |
F24 | =E24 | |
F25 | =E25 | |
F26 | =SUM(F16:F25) | |
F29 | =E29 | |
F30 | =E30 | |
F31 | =E31 | |
F32 | =E32 | |
F33 | =E33 | |
F34 | =E34 | |
F35 | =E35 | |
F36 | =E36 | |
F37 | =E37 | |
F38 | =E38 | |
E14 | =SUM(E3:E12) | |
E26 | =SUM(E16:E25) |