Its possible with formula, however a formula cannot "copy" any thing it
simply displays results, that said it can be done with a series of
VLOOKUP's perhaps, however if you do not have unique names vlookup will
only give you the first result, are the names going to be unique?Paul Rimmer;422535 Wrote:
I'm using Office 2003. I'm trying to search for a name on 1 work sheet &
when
this is found, I want to copy this & the following data in the next few
columns onto a seperate work sheet. Is this possible as a formula or
will it
have to be VBA??

For Example:

I search for John Smith in column A & when this has been found, the
information in column A to column J needs to be copied on a seperate
worksheet.

Thanks in advance for the assistance

Paul


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=117521