Lookup values in a list and return multiple rows of data

[Guest]

Hi there,

I am trying to lookup data in a column and if it matches a particular value
and want to copy the whole row to a new worksheet. There will be more than
one row that matches the value so I accnot use VLookup. Can anyone suggest
an approach please?

Many thanks,

Amanda

 

[Frank Kabel]

Hi
try using Ron's EasyFilter addin for this:
http://www.rondebruin.nl/easyfilter.htm

 

[Alan Beban]

Hi there,

I am trying to lookup data in a column and if it matches a particular value
and want to copy the whole row to a new worksheet. There will be more than
one row that matches the value so I accnot use VLookup. Can anyone suggest
an approach please?

Many thanks,

Amanda

You might want to consider the ArrayRowFilter1 function in the freely
downloadable file at http://home.pacbell.net/beban.

Alan Beban