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