ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   invoice on sheet 1 & data store on sheet 2 automatically (https://www.excelbanter.com/excel-discussion-misc-queries/249332-invoice-sheet-1-data-store-sheet-2-automatically.html)

Sudipta Sen[_2_]

invoice on sheet 1 & data store on sheet 2 automatically
 
Dear friends,

I want to create an Invoice format on sheet 1, where I want to entry one by
one invoice and also I want store the data of each invoice on sheet 2
automatically (like form feeding, but on excel worksheet, so I could take the
print out of each invoice with border & Company Name).

Have any solution?
Pls. help me to get that

Rdgs......Sudipta

Luke M

invoice on sheet 1 & data store on sheet 2 automatically
 
Check out Debra's recent article on creating invoices:

http://blog.contextures.com/archives...excel-invoice/
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Sudipta Sen" wrote:

Dear friends,

I want to create an Invoice format on sheet 1, where I want to entry one by
one invoice and also I want store the data of each invoice on sheet 2
automatically (like form feeding, but on excel worksheet, so I could take the
print out of each invoice with border & Company Name).

Have any solution?
Pls. help me to get that

Rdgs......Sudipta


Dave Peterson

invoice on sheet 1 & data store on sheet 2 automatically
 
Maybe you can use this idea from Debra Dalgleish's site:
http://contextures.com/xlForm02.html
and
http://contextures.com/xlForm03.html

Sudipta Sen wrote:

Dear friends,

I want to create an Invoice format on sheet 1, where I want to entry one by
one invoice and also I want store the data of each invoice on sheet 2
automatically (like form feeding, but on excel worksheet, so I could take the
print out of each invoice with border & Company Name).

Have any solution?
Pls. help me to get that

Rdgs......Sudipta


--

Dave Peterson


All times are GMT +1. The time now is 07:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com