Name your list of names and do a loop or just use a vlookup formula

for each name in [mylistofnames]
code
next

--
Don Guillett
SalesAid Software

"Tempy" wrote in message
...
Could you please give me some more advice on this topic.

I need to look for 19 different names and put the totals in a column. Is
it possible to have a list of names, perhaps in my Personal.xls
workbook, and with the code find the results for one name, paste it and
then get the next name, until the end of the list ?


Tempy

*** Sent via Developersdex http://www.developersdex.com ***