Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pull Specific Values | Excel Discussion (Misc queries) | |||
Excel pull data based upon one specific word between two date | Excel Worksheet Functions | |||
Link from a specific Cell in Excel to a specific para. in Word | Excel Worksheet Functions | |||
Pull and store a value on specific date in another cell | Excel Worksheet Functions | |||
Can a worksheet pull from a specific cell value in a separate wrks | Excel Worksheet Functions |