Invoice Create and Edit

June 20, 2013 at 23:27:29
Specs: Windows XP
in sheet1 i created basic invoice template in such way in b1 is invoice number in a2 date, in b2 customer name, in c2 product, in d2 qty, in e2 rate, in f2 amount = rate x qty. and on sheet1 i created save command button. and in sheet2 from A1:G1 is title like Invoice no, Date, Customer no, Product, Qty, Rate, Amount now when i click save on save button on sheet1, the sheet1 data goes in sheet2 and in their respective fields and gets saved with "Edit" hyperlink at end of each invoice in sheet2 in H2. when i click on this edit button the invoice gets open and when i make some changes and save and close that edited invoice the databse that i created on sheet2 of that particular invoice doesnt effect on changes. so please help.

See More: Invoice Create and Edit

June 21, 2013 at 10:22:14
Without seeing the code for the "Edit" button, it's kind of hard for us to determine why your changes are not being saved.

Is the Save operation part of the macro behind the Edit button or are you simply using Excel's basic File...Save steps?

We need to know a little bit more about how you use the workbook before we could offer any suggestions.

If you plan on posting any VBA code, please click on the following line and read the instructions found via that link.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question