Type 2 as Invoice No, ON as State Code (code for Ontario), and for having today’s date, we used the TODAY function. Fill in the banking details. Use your desired A/C Name and A/C No. (we used Michael James and 0034567). Method 2 – Make Dropdown List Make a dropdown list ...
Sr.No.HSN CODEITEM NAMEQtyUnit PriceTotal Value 1ABCD1011110 2ABCD5511605 3 4 5EFGH179153 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Sub Total Tax Discount Total868 This is INVOICELIST Sheet
Sheets("INVOICELIST").Range("B" & i).Value = Sheets("INVOICE").Range("F1").Value 'Copy Date Sheets("INVOICELIST").Range("A" & i).Value = Sheets("INVOICE").Range("F2").Value 'Copy Company Name Sheets("INVOICELIST").Range("C" & i).Value = Sheets("INVOICE").Range("D5")....
HSN code for the goods. / SAC code for services, if any. Description of goods. Quantity of goods supplied. Taxable value of supply and the GST tax rate applied. Transportation charges, if any Place of supply, in case of inter-state movement of goods. ...
I created a flow to retrieve the report information and signature images from the app and upload them to a Sharepoint list + doc library. All of this work perfectly. I also want to output the captured information (+signatures) in a template that can be converted to PDF ...
VBA CODE: Sub SaveData() Dim rng As Range Dim temp As Variant Dim i As Long Dim a As Long Dim rng_dest As Range Application.ScreenUpdating = False i = 1 Set rng_dest = Sheets("INVOICELIST").RangeColumn("D:T") ' Find first empty row in columns D:T on sheet INVOICELIST ...
This is very confusing, both for you and for the people who try to help you. In the future, please don't start new discussions for the same question. Sr.No.HSN CODEITEM NAMEQtyUnit PriceTotal Value 1 179153 Tax Dim rng As Range ...
VBA CODE: Sub SaveData() Dim ws As Worksheet Dim wt As Worksheet Dim s As Long Dim t As Long Dim r As Long Application.ScreenUpdating = False Set ws = Worksheets("INVOICE") Set wt = Worksheets("INVOICELIST") ' Find first empty row in columns D:AL on sheet INVOICELIST ...
VBA CODE: Sub SaveData() Dim ws As Worksheet Dim wt As Worksheet Dim s As Long Dim t As Long Dim r As Long Application.ScreenUpdating = False Set ws = Worksheets("INVOICE") Set wt = Worksheets("INVOICELIST") ' Find first empty row in columns D:AL on sheet INVOICELIST ...
VBA CODE: Sub SaveData() Dim ws As Worksheet Dim wt As Worksheet Dim s As Long Dim t As Long Dim r As Long Application.ScreenUpdating = False Set ws = Worksheets("INVOICE") Set wt = Worksheets("INVOICELIST") ' Find first empty row in columns D:AL on sheet INVOICELIST ...