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

Check out Debra's recent article on creating invoices:

http://blog.contextures.com/archives/2009/11/23/print-selected-items-on-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

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