Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How do I pull a specific name based on a specific value from mult.

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pull Specific Values KW[_2_] Excel Discussion (Misc queries) 1 April 27th 07 09:34 AM
Excel pull data based upon one specific word between two date klmiura Excel Worksheet Functions 7 October 26th 06 09:46 PM
Link from a specific Cell in Excel to a specific para. in Word CathyK Excel Worksheet Functions 0 August 10th 06 04:40 PM
Pull and store a value on specific date in another cell Brian Excel Worksheet Functions 3 November 1st 05 10:49 PM
Can a worksheet pull from a specific cell value in a separate wrks reloanpro Excel Worksheet Functions 4 June 27th 05 10:03 PM


All times are GMT +1. The time now is 06:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"