Ajay Raghatate (Sr Executive (Excise & Accounts)) (736 Points)
26 July 2010Can 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
Sujit Talukder
(service)
(719 Points)
Replied 26 July 2010
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
Ajay Raghatate
(Sr Executive (Excise & Accounts))
(736 Points)
Replied 26 July 2010
Attached
Sujit Talukder
(service)
(719 Points)
Replied 26 July 2010
Your smaple file doesnot contain any data. How can I work with blank data? No invoice can be generated with blank data
regards
Sujit
Ajay Raghatate
(Sr Executive (Excise & Accounts))
(736 Points)
Replied 26 July 2010
Attached revise sheet
Sujit Talukder
(service)
(719 Points)
Replied 26 July 2010
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.
Ajay Raghatate
(Sr Executive (Excise & Accounts))
(736 Points)
Replied 26 July 2010
Thanks Sujit,
Thank u so much.,
CAclubindia
