Tranfer Invoice data to another excel sheet using vba

  • I am new here and also new in Excel VBA. After viewing different YouTube videos and online platforms I have tried to make this .xlsm file in excel to transfer Invoice data in another sales sheet. But there is an error and I can not rectify it.

    I also want to transfer Invoice Grand total amount to Sales sheet.

    Please help me.

  • The VBA Code is Here

  • Assumes that "Type" is the same as "SI No" and that C29 is the "Invoice Total".

    Change as required.

    Make sure that the unused cells in Column A between A10 and A34 are empty.

    Copy and paste code into a regular module.