Copy to new sheet by party wise and date wise.

[john5599]

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)

 

[ca.moazzam]

The columns wherein you have party and dates don't seem to have any entries against rows in which totals have been done so it's simple. Select the whole data and choose Data- Auto filter. Then either filter date column or party column to deselect (blanks). The filtered rows will now contain data without subtotals. Select / copy the required data, go to other sheet and paste.

Moazzam

 

[john5599]

The columns wherein you have party and dates don't seem to have any entries against rows in which totals have been done so it's simple. Select the whole data and choose Data- Auto filter. Then either filter date column or party column to deselect (blanks). The filtered rows will now contain data without subtotals. Select / copy the required data, go to other sheet and paste.

Moazzam

I need a macro or Vlookup to solve this problem. Every part has heading Tax Exempted, Tax 12.5%, and Tax 5%.