mianmazher
Active Member
- Joined
- Jan 24, 2004
- Messages
- 412
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Order No. | Party Name | Station | Receiving Date | Trucks | ||
2 | 1000 | A | NY | 20-02-04 | 1 | ||
3 | 1001 | B | MI | 20-02-04 | 1 | ||
4 | 1002 | C | IL | 21-02-04 | 4 | ||
5 | 1005 | D | NJ | 21-02-04 | 2 | ||
6 | 1005A | E | NY | 21-02-04 | 1 | ||
7 | 1006 | F | CANADA | 22-02-04 | 5 | ||
8 | 1007 | G | TRONTO | 22-02-04 | 1 | ||
9 | 1008 | H | MEXICO | 22-02-04 | 1 | ||
Received |
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Order No. | Party Name | Station | Received date | Trucks | ||
2 | 1000 | A | NY | 21-02-04 | 1 | ||
3 | 1002 | C | IL | 22-02-04 | 2 | ||
4 | 1005 | D | NJ | 22-02-04 | 2 | ||
5 | 1006 | F | CANADA | 23-02-04 | 2 | ||
6 | 1007 | G | TRONTO | 23-02-04 | 1 | ||
7 | 1008 | H | MEXICO | 23-02-04 | 1 | ||
Despatched |
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Order No. | Party Name | Station | Receiving Date | Trucks | ||
2 | 1001 | B | MI | 20-02-04 | 1 | ||
3 | 1002 | C | IL | 21-02-04 | 2 | ||
4 | 1005A | E | NY | 21-02-04 | 1 | ||
5 | 1006 | F | CANADA | 22-02-04 | 3 | ||
Balance |
I want the balance Order sheet to be claculated automatically
the list should be sorted automatically and should not show the items that have been despatched
I have a long list of datain the received sheet abt 1000 records
I need the sheet Balnce to be claculated automatically