Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Invoice
Suppose Want to make Invoice 1 to 100 (like form feeding) in sheet 1 and the
datas will be save automatically on sheet 2, and if require I could print supose Invoice no 45 later , so I could do it. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Invoice
Hi Sudipta Sen,
This is something far beyond what one simple worksheet function could do. I would suggest you would need to write some macros to do what you would like. You would have cells for the data entry for the invoice data, and then a save button. The macro for this button would then copy the data to the second sheet in a row for that invoice. It would then update the invoice number and you could start again. You would then need a dropdown field and a second button to select the invoice to reprint. The code would retrieve the data from the second sheet, copy it back into the first sheet in the invoice layout and then you could print it. You might need to look into learning some VBA first. Cheers, Nick -- Nicholas Perkins Excel Analyst, Designer and Programmer http://www.nicholasperkins.com/ is bad.com (Please remove the spamisbad) "Sudipta Sen" wrote: Suppose Want to make Invoice 1 to 100 (like form feeding) in sheet 1 and the datas will be save automatically on sheet 2, and if require I could print supose Invoice no 45 later , so I could do it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
invoice toolbar for invoice calcuation and assign number | Excel Discussion (Misc queries) | |||
missing invoice toolbar when save customised invoice | New Users to Excel | |||
Invoice templet Excel97 to 2003 invoice toolbar missing | Excel Discussion (Misc queries) | |||
How do I display the invoice toolbar for unique invoice #'s? | Excel Discussion (Misc queries) | |||
How do I change the invoice number assigned in Invoice template... | Excel Discussion (Misc queries) |