I think this is probably a VBA task in Excel - have you considered using
Access? Harder to set you but you can do the sort of thing you want much more
efficiently

Sheila
www.c-i-m-s.com

"Newtonboy" wrote:


Hello All,

I have data in running form, something like this:

-----------------------------------------------------------------
Sl. No. Date InvoiceNo. Item Pcs Price Value
-----------------------------------------------------------------
1 29-Aug 001 Spanner 1 11.00 11.00
2. 29 Aug 001 Hammer 2 10.00 20.00

etc.

etc.

Now from this, Can we have a way of printing all the info of one
invoice number, say 001 in anoter sheet which has a different format ?
Pls help.

Thanks,
Ajit


--
Newtonboy
------------------------------------------------------------------------
Newtonboy's Profile: http://www.excelforum.com/member.php...o&userid=29582
View this thread: http://www.excelforum.com/showthread...hreadid=558163