r/sir
i am create a 8 check boxes than i am select 3 check boxes & click on the "copy selected rows" button the selected check boxes Rows was paste to the invoice after invoice total amount
i am insert a vba code for Copy selected rows (check boxes) but this vba code was not working correctly, than i am Select on the 3 Check Box & Click On the "copy selected rows" button
but only 1st selected Check box (OUTPUT VAT @ 5%) was paste on the invoice sheet after total amount & other 2 selected check boxes was not paste on the invoice sheet ,the subtotal total Line Auto Add After Vat & Grand total line are auto add before,
than i am select a 4 check box the 4 selected check box was added in this invoice sheet, if i am select a 5 check box the 5 check box was added in this invoice sheet, subtotal & Gran Total Lines Are auto added in this lines, & Auto insert Calculation Formula in this all these selected line
for Example
Total 9000
Output vat @ 5% 450 Only Selected check box Added (& Auto insert Calculation Formula in this line)
Sub Total 9450 This Line Auto Add After Vat (& Auto insert Calculation Formula in this line)
Round Off - Only Selected check box Added (& Auto insert Calculation Formula in this line)
Fright Charges 150 Only Selected check box Added (& Auto insert Calculation Formula in this line)
Grand Total 9600 This Line Auto Add After Vat (& Auto insert Calculation Formula in this line)
please find the attachments & Correct this vba code
Bookmarks