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