Invoice making in Excel & VBA

  • please help. I am waiting for the help.......


    Trying to make Invoice in excel & VB. But I am facing series of problems. I am new in VBA with excel .Kindly Help. A sample file is attached


    1) IF same invoice is saved multiple time , it is not showing : Invoice Already Exist.. Do you want to Overwrite


    2) The blank line of Invoice B13:H27 are getting populated in Invoice Data. How to get only the lines which are filled?


    3) How to reset Invoice No. in C7 ( since I have copied the VBA , I don’t know how to do it)
    4) How to make the date F2 mandatory [ATTACH]n1205063[/ATTACH]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!