Dear All,

I am new to this group.

I have an excel sheet where in the sales informations (like Invoice #,
quantity, price, name of the party, mode of transport, payment method, due
date, discount etc)in a row and there are several hundred rows.

Now in a separate sheet I want these datas in Invoice format. When I put a
particular row number (like "A15") then the datas relating to that rows will
automatically come into an Invoice format.

Can any one explain how to do it.

Your help is much appreciated.

Thanks in Advance.
Thiru