Can anyone tell me,
How can I prepare Invoice in Excel, (or any other program) if there are some fixed details i.e Name of Company Date Reg No, Add.,
I just want fill up the data in specified field, in a data field & Invoice will generate automatically. with the data,
I am waiting your valued suggestions
Thanks
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
CAclubindia
