Invoice

Hello Experts,

I m trying to make an invoice for my office. The invoice format is already printed. I have made an excel file which contains the same format as in the paper (so that it be printed from Excel).

I need help to do following task.

1. For that invoice, when we click a button, it should open a new sheet in same workbook with an invoice number. Invoice Number should be in series. (if last sheet is 00169, new sheet is 00170.

I have attached the required excel format. I require a button, which on click should open a new sheet with master format as well as formulas.

Thanks in advance !

Hi i don't know if this answer your question

Originally Posted by pierre08

Hi i don't know if this answer your question

Thanks for quick reply..
But i am getting error

"An error occured initializing the VBA libraries (40040)."

Please help to solve this issue !!

Hi,
i don't know if this answer your question