Invoice Preparation in Excel

Post a sample file How you will input tha data nad how outpput is needed.

To generate invoices automatically, macros are required.

Post the sample file, I will try

regards

Sujit

Attached

Your smaple file doesnot contain any data. How can I work with blank data? No invoice can be generated with blank data

regards

Sujit

Attached revise sheet

Please find the attached file.

In the macro code, I used Print Preview command. You can change the code line from:

Targetsht.PrintPreview

to

Targetsht.PrintOut

to take the print of all the invoices in your data sheet.

Also note Dont use any formula in Invoice Sheet. You can use formula in Data sheet. Invoice sheet will pick those values from Data sheet automatically.

Hope this will serve your purpose.

Thanks Sujit,

Thank u so much.,

Glad to help.

regards

sujit