making an employee schedule in two sheets

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

Guest

I am making an employee schedule. One sheet is their names with their station
assignment, the other sheet is the station assignments with their names. How
do I type say Amanda and her stations and have her name go to the station on
the next sheet?
 
suppose your data is from A1 ti B5 in sheet1 as follows
amanda a
amanda s
amanda d
linda f
linda g

in sheet 2 type A1 to A5 is as follows
a
s
d
f
g

in this sheet (sheet2 ) type in B1
=OFFSET(Sheet1!B1,0,-1,1,1)
your will get amanda

drag B1 down you will get
a amanda
s amanda
d amanda
f linda
g linda

perhaps better soluton may be suggested.
 

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

Help with schedule 4
Adding up total hours worked on employee schedule using various criteria 0
Some people have no sense 1
linking cells with scheduling workbook 2
Is this even possible?? 1
LINKING TABLES IN EXCEL 1
Employee Scheduling Worksheet 10
Reference column 14

Back
Top