extracting names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,

i am using an excel worksheet for an employee schedule for about 60 people.
i need to make a daily workload for each day of the week and print it. i
inserted 7 worksheets within my sched worksheet. for sunday which will be say
sheet 1, if i enter an employee for that day, i want the worksheet to pickup
the shift and dept for that employee. eg if i enter in a1 in workshhet 1
"bob" whose name is on a29 in the sched worksheet, i need a2 and a3 in sheet
1 to pickup bob's shift and dept which is e29 and e30. and the same for the
names i enter down the list. the names i enter may be in random order. eg bob
(a29), joe (a31), pat (a47), tim (a131), etc
any ideas? thanks in advance
 
If you can re-arrange your schedule so that the information for each employee
is on one line (ie move dept to column F), you could use a Lookup.


Assuming your schedule is on a worksheet called Schedule, cells A1:F200:
=VLookup(A1, Schedule!$A$1:$F$200, 5, 0)
=VLookup(A1, Schedule!$A$1:$F$200, 6, 0)

Change ranges as needed, then copy down. The lookup will return the first
instance of the name you are looking up, so you'll need to make sure the
names are unique, or use something else as a "key", such as an employee
number.
 
i tried that, still pop up a values update:schedule box
could it be because i'm trying to use the workload sheet in the same
workbook as the sched?
 
vlookup should work fine with the workload sheet and schedule sheet in the
same workbook.

what version of XL do you have? the only time I've seen messages pertaining
to updating values is when my workbook contains links to another workbook.
 
i got microsoft excel xp pofessional


JMB said:
vlookup should work fine with the workload sheet and schedule sheet in the
same workbook.

what version of XL do you have? the only time I've seen messages pertaining
to updating values is when my workbook contains links to another workbook.
Click to expand...
 
Is that XL2002? Perhaps see if you can save a copy as XL 2000 and email it
to me (if you wish) and I'll see if there's anything else I can do.

jeffblakleyAThotmailDOTcom
 

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

extracting names, shifts dept from excel worksheet 1
extract of data with 3 different conditions? 10
Searching worksheet and exporting name to other sheet 1
SUMIF? 9
Lookup on worksheet 1
Dependent list in excel to create validation 1
Detailed worksheet value entered automatically in Summary workshee 2
Not split... break apart? 5

Back
Top