Hi pooja

For a code example see
http://www.rondebruin.nl/copy5.htm

Or you can use EasyFilter
http://www.rondebruin.nl/easyfilter.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"pooja" wrote in message ...
Hello,
I am having trouble extracting data from 2000 line items with information
attached to them across 15 columns.
I have 100 group number(cost center) that needs to be extracted from these
2000 line items along with there information(ex title, action etc), there is
also a column for cost center.
I tried using vlookup, and advanced filter but nothing works.
Please help me with this, as this is very urgent and needs to be submitted.

Thanks and Regards