View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default How do I pull a specific name based on a specific value from mult.

What you are wanting to do can be done using the VLOOKUP formula(s), the
details being specific to your application.........however, I would recommend
that your database not be spread out over multiple sheets..........if they
were all in one long list then the Autofilter would quickly produce the
report you're seeking.

Vaya con Dios,
Chuck, CABGx3



"rpctoo" wrote:

I would like to pull a specific name from a spreadsheet to another one based
on the value associated with it. For instance: I have multiple students in
different classes assigned to the same computer. . . I would like to print
the list of users for a specific computer without having to copy and paste
from each worksheet.