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)
