TMIbyndoor
New Member
- Joined
- Jun 17, 2018
- Messages
- 1
i had one excel sheet .there is 6 column there quantity, recievd qnty ,,balance qty, rate ,tax 5%,and Discount in %. . i need last cell used all[TABLE="width: 3693"]
<colgroup><col><col span="2"><col><col><col span="2"><col span="10"><col span="2"><col span="2"><col><col><col span="2"><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 22"]Material Received Detail (With GRN)[/TD]
[TD="colspan: 9"]Total Amount [/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[TD]Do/Inv No[/TD]
[TD]Date[/TD]
[TD]GRN[/TD]
[TD]Qty[/TD]
[TD]Do/Inv No[/TD]
[TD]Date[/TD]
[TD]GRN[/TD]
[TD]Qty[/TD]
[TD]Do/Inv No[/TD]
[TD]Date[/TD]
[TD]GRN[/TD]
[TD]Qty[/TD]
[TD]Do/Inv No[/TD]
[TD]Date[/TD]
[TD]GRN[/TD]
[TD]Qty[/TD]
[TD]Do/Inv No[/TD]
[TD]Date[/TD]
[TD]GRN[/TD]
[TD]Qty[/TD]
[TD]Rcvd Qty[/TD]
[TD]Balance Qty[/TD]
[TD]Rate[/TD]
[TD]Currency[/TD]
[TD]Discount %[/TD]
[TD]Price [/TD]
[TD]5% VAT[/TD]
[TD]Discount Amount[/TD]
[TD]Total (AED)[/TD]
[TD]Discounted PO Amount[/TD]
[TD]Total Amount [/TD]
[/TR]
[TR]
[TD]I 318/943[/TD]
[TD]06/03/2018[/TD]
[TD]690385[/TD]
[TD]1.0000[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]1.0000[/TD]
[TD]0.0000[/TD]
[TD]95,000.000[/TD]
[TD]AED[/TD]
[TD]0[/TD]
[TD]95,000.000[/TD]
[TD]4,750.000[/TD]
[TD]0.000[/TD]
[TD]99,750.000[/TD]
[TD]99,750.000[/TD]
[TD] 99,750.000[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0.0000[/TD]
[TD]1.0000[/TD]
[TD]500.000[/TD]
[TD]AED[/TD]
[TD]0[/TD]
[TD]500.000[/TD]
[TD]25.000[/TD]
[TD]0.000[/TD]
[TD]525.000[/TD]
[TD]525.000[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0.0000[/TD]
[TD]1.0000[/TD]
[TD]500.000[/TD]
[TD]AED[/TD]
[TD]0[/TD]
[TD]500.000[/TD]
[TD]25.000[/TD]
[TD]0.000[/TD]
[TD]525.000[/TD]
[TD]525.000[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0.0000[/TD]
[TD]1.0000[/TD]
[TD]700.000[/TD]
[TD]AED[/TD]
[TD]0[/TD]
[TD]700.000[/TD]
[TD]35.000[/TD]
[TD]0.000[/TD]
[TD]735.000[/TD]
[TD]735.000[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
cell in one answer
<colgroup><col><col span="2"><col><col><col span="2"><col span="10"><col span="2"><col span="2"><col><col><col span="2"><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 22"]Material Received Detail (With GRN)[/TD]
[TD="colspan: 9"]Total Amount [/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[TD]Do/Inv No[/TD]
[TD]Date[/TD]
[TD]GRN[/TD]
[TD]Qty[/TD]
[TD]Do/Inv No[/TD]
[TD]Date[/TD]
[TD]GRN[/TD]
[TD]Qty[/TD]
[TD]Do/Inv No[/TD]
[TD]Date[/TD]
[TD]GRN[/TD]
[TD]Qty[/TD]
[TD]Do/Inv No[/TD]
[TD]Date[/TD]
[TD]GRN[/TD]
[TD]Qty[/TD]
[TD]Do/Inv No[/TD]
[TD]Date[/TD]
[TD]GRN[/TD]
[TD]Qty[/TD]
[TD]Rcvd Qty[/TD]
[TD]Balance Qty[/TD]
[TD]Rate[/TD]
[TD]Currency[/TD]
[TD]Discount %[/TD]
[TD]Price [/TD]
[TD]5% VAT[/TD]
[TD]Discount Amount[/TD]
[TD]Total (AED)[/TD]
[TD]Discounted PO Amount[/TD]
[TD]Total Amount [/TD]
[/TR]
[TR]
[TD]I 318/943[/TD]
[TD]06/03/2018[/TD]
[TD]690385[/TD]
[TD]1.0000[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]1.0000[/TD]
[TD]0.0000[/TD]
[TD]95,000.000[/TD]
[TD]AED[/TD]
[TD]0[/TD]
[TD]95,000.000[/TD]
[TD]4,750.000[/TD]
[TD]0.000[/TD]
[TD]99,750.000[/TD]
[TD]99,750.000[/TD]
[TD] 99,750.000[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0.0000[/TD]
[TD]1.0000[/TD]
[TD]500.000[/TD]
[TD]AED[/TD]
[TD]0[/TD]
[TD]500.000[/TD]
[TD]25.000[/TD]
[TD]0.000[/TD]
[TD]525.000[/TD]
[TD]525.000[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0.0000[/TD]
[TD]1.0000[/TD]
[TD]500.000[/TD]
[TD]AED[/TD]
[TD]0[/TD]
[TD]500.000[/TD]
[TD]25.000[/TD]
[TD]0.000[/TD]
[TD]525.000[/TD]
[TD]525.000[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0.0000[/TD]
[TD]1.0000[/TD]
[TD]700.000[/TD]
[TD]AED[/TD]
[TD]0[/TD]
[TD]700.000[/TD]
[TD]35.000[/TD]
[TD]0.000[/TD]
[TD]735.000[/TD]
[TD]735.000[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
cell in one answer