Microsoft Excel - Copy to new sheet by date wise and party wise
Asked By John on 29-Jan-13 12:49 PM
| |
Tax Exempted |
|
|
| Date |
Party Name |
Bill No. |
Amount |
| 22/06/2026 |
Jackson company |
3 |
11,573.48 |
| 22/06/2026 |
Primer associates |
5 |
41,316.07 |
| 14/08/2025 |
Rital corporation |
11 |
9,155.67 |
| 10/09/2025 |
Jackson company |
19 |
10,329.02 |
| 14/12/2025 |
Primer associates |
53 |
13,871.43 |
| 05/12/2025 |
Jerry and Bros |
46 |
4,444.50 |
| 08/12/2025 |
Jimmy George |
48 |
4,444.50 |
| 20/12/2025 |
Jerry Varghese |
59 |
5,555.63 |
| 24/12/2025 |
Akash Associates |
61 |
7,081.49 |
| 27/12/2025 |
Mithila Enter prises |
66 |
6,888.98 |
| 20/10/2025 |
Akash Associates |
29 |
10,230.40 |
| |
|
Total = |
114,660.77 |
| |
Tax 12.5% |
|
|
| 22/06/2026 |
Jerry and Bros |
2 |
40,468.13 |
| 22/06/2026 |
Jimmy George |
6 |
252,237.84 |
| 15/07/2026 |
Akash Associates |
8 |
19,583.40 |
| 14/08/2025 |
Jackson company |
10 |
223,666.27 |
| 24/08/2025 |
Primer associates |
14 |
69,814.81 |
| 10/09/2025 |
Mithila Enterprises |
18 |
11,093.00 |
| 19/09/2025 |
Primer associates |
21 |
15,421.77 |
| 25/09/2025 |
Jimmy George |
22 |
23,103.32 |
| 14/12/2025 |
Rital corporation |
54 |
10,705.46 |
| 24/12/2025 |
Primer associates |
63 |
5,688.90 |
| |
|
Total = |
671,782.90 |
| |
5% |
|
|
| Date |
Party Name |
Bill No. |
Amount |
| 22/06/2026 |
Jackson Company |
1 |
42,976.45 |
| 22/06/2026 |
Akash Associates |
4 |
186,794.92 |
| 15/07/2026 |
Jerry and Bros |
7 |
171,726.50 |
| 14/08/2025 |
Jimmy George |
9 |
81,371.71 |
| 18/08/2025 |
Jackson company |
12 |
281,825.39 |
| 24/08/2025 |
Akash Associates |
13 |
25,867.86 |
| 01/09/2025 |
Rital Corporation |
15 |
35,224.27 |
| 02/09/2025 |
Primer associates |
16 |
16,501.02 |
| 05/09/2025 |
Jimmy George |
17 |
16,320.76 |
| 10/09/2025 |
Mithila Enter prises |
20 |
17,174.13 |
| |
|
|
|
Donald Ross replied to John on 29-Jan-13 08:39 PM
John
Is that all your data? and if so what kind of order is it in? the dates are not in order the bill number is not in order and the amount is not in any order.
You have tax exempt, 12.5% tax and 5% tax list do you want to keep them separate or are you looking to join the list based soley on the date range for one page and then by party name on another.
I think the best thing would be for you to create a pivot table.
and you may have to add a new colum to put the tax information in.
it might look something like this when you are done.
just a thought Don
John replied to Donald Ross on 29-Jan-13 09:27 PM
I would like to have a macro to copy this to new page, as per 12.5,5 and Tax exempted by date wise and party wise
John replied to Donald Ross on 29-Jan-13 09:46 PM
I would like to copy date wise and party wise to another sheet by Tax exempted, 12.5, and 5%. If it possible with macro it is better.
Donald Ross replied to John on 30-Jan-13 05:59 AM
You can probably accomplish this without a macro, and just use something like vlookup, to populate your other three sheets as you go I will work on something when I get to work, that would be simple for you.
Don
John replied to Donald Ross on 01-Feb-13 12:07 PM
sir any command like index or match to copy party name to another sheet?