How do I pull a specific name based on a specific value from mult.

R

rpctoo

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.
 
C

CLR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Finding the right style field in VBA 0
Automation of scanned file storage based on content 0
How do I convert shading to highlighting for specific colors 8
VBA Coding Help for Beginner 0
Summing Results Based On A Specific Date 2
New computer, how do i move outlook 365 ENTIRELY? 0
Pasting a cell into bookmarked table from excel vba 1

Top