TheBuGz
Spammer
- Joined
- Jan 25, 2004
- Messages
- 367
Here is what i am trying to make an Invoice like this
i have a price list in another sheet . I want that i write Product ,Quality and Quantity the Rest of things are picked up from the Price List in another sheet of the same workbook. The Discount is also mentioned along with the Name of Quality Ill show u in the next Post
Order.xls | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | |||||||||||||
2 | |||||||||||||
3 | PROD | QLTY | QTY | PRICE | DISC | PRICEAFTERDISC | NETAMOUNT | VolPerPiece | TotalVolume | ||||
4 | 22x22x4 | FS | 100 | 357 | 50 | 178.5 | 17850 | 1,936 | 193600 | ||||
5 | 22x18x3 | D | 150 | 177 | 50 | 88.5 | 13275 | 1,188 | 178200 | ||||
6 | 78x60x5 | FSP | 25 | 2300 | 0 | 2300 | 57500 | 23,400 | 585000 | ||||
7 | Gao | BQ | 25 | 125 | 0 | 125 | 3125 | 2,000 | 50000 | ||||
8 | Pillow | BQ | 100 | 70 | 0 | 70 | 7000 | 1,700 | 170000 | ||||
9 | |||||||||||||
10 | |||||||||||||
11 | TotalAmount | 98,750 | 1,176,800 | ||||||||||
12 | |||||||||||||
13 | TotalVolume | 1,176,800 | |||||||||||
14 | |||||||||||||
Sheet1 |
i have a price list in another sheet . I want that i write Product ,Quality and Quantity the Rest of things are picked up from the Price List in another sheet of the same workbook. The Discount is also mentioned along with the Name of Quality Ill show u in the next Post