Invoice

S

Sudipta Sen

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.
 
N

Nicholas Perkins

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/
(e-mail address removed) bad.com
(Please remove the spamisbad)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top