finding data in the same sheet
 

Hi, I wonder if any one can help I have a work sheet where in A4 down to A40,
I type in a list of names, B4 to Y4 down to B40 and Y40 contains data with an
average in Z4to Z40. In AP4 down to AP 80 I have another list of names which
I need to keep in the same order.
What I would like to do is: - say AP4 Has the name John Doe in it, I would
like to look in A4 to A40 find John Doe and copy the figure in Z4 to Z40 so
if John Doe is in A5 then copy the data from Z5 and paste it into AQ4.
I would then like to make 28 copies of the sheet in the workbook.
Thank you in advance to any one who has a go at this.
Barry.

finding data in the same sheet
 

For this part of it:
What I would like to do is: - say AP4 Has the name John Doe in it, I would
like to look in A4 to A40 find John Doe and copy the figure in Z4 to Z40 so
if John Doe is in A5 then copy the data from Z5 and paste it into AQ4.

You could try placing in AQ4:
=IF(ISNA(MATCH(AP4,A:A,0)),"",INDEX(Z:Z,MATCH(AP4, A:A,0)))
then copy AQ4 down. Freeze col AQ with an "in-place" copy n paste special as
values.

p/s: Keep it to one query per thread. Keep it attractive for responders to
respond. You'd need a macro to do the 2nd part. If no other responder jumps
in this thread with something for you, try posting in .programming.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---

finding data in the same sheet
 

Ah, darned. You were, like many others, an unfortunate victim of the
misleading error msgs thrown up in MS' web newgroups of late in wrongly NOT
confirming that posts made have gone through when in fact, they had gone
through. This accounts for your many repeat posts.

Treat the index/match suggested as an alternative to what Pete has given you
earlier in your other post.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---