Hi,

You can use Advanced Filters here. Advanced filters are very well explained
in the Help menu.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"vijaydsk1970" wrote in message
...
Once again thanks for all the previous help from these forum.
Here my problem is
i need to lookup up multiple values existing in a sheet and copy them in
to
my quotation sheet. in other words i will have a customer reference
number
in one column. basing on this reference number Excel should copy and
paste
all the matching values in the next column to my quotation sheet (in row
after row).

Apologies if my example cannot give what exactly i am looking for.

Any speedy help would be really appreciable.