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

--
Regards
Frank Kabel
Frankfurt, Germany

"Amanda L" <Amanda schrieb im Newsbeitrag
...
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