Hi all,

I am working on a schedule for a healthcare center & need to pull data
from the monthly sched workbook into the daily sched workbook. For each
day in the daily sched workbook, there are two sheets -- one for each
station. The MrExcel MB helped provide a code to create and name these
sheets - now that I've got the two sheets ready to sync, I'm stuck.

My goal is to pull the nurses name & shift info into the correct sheet
on the correct day, on the correct tab.

To finish this job, I can isolate the worksheet by matching the date -
but am struggling with isolating the workstation information. Here's
how the data differs:

Nov 03 ab (from the daily worksheets tab name)
and
b (from the monthly rotation column)

There is also a cell in the daily workbook with the station
information, but it's preceded by 94 characters -- then the station
info: "A / B" or "C / D / E". My skills with splitting cell info aren't
up to this puzzle. I know that I can isolate the info from the cell
with "Right(b1,6)" but don't know how to use this to send the correct
info to the correct tab... (in short -- if a or b, then look for date
and hours under date, then nurse name in the row and put name in the
correct row on tab ab)

Finally, after the matches have isolated the data -- I need to pull in
all of the names from the "A" column that match the above criteria in
the monthly workbook and populate the row in the daily workbook with
the appropriate name. Then, pull the shift info in from the appropriate
day column in the monthly sched workbook.

Here is a rough idea of the formatting:


Monthly sched. workbook (just the pertinent data)

column 1 = first name
column 2 = last name
column 4 = rotation
row 3 = date (31 cols across)
shift data area E4:AI65

Daily sched. workbook

cell L1 = date
row 2 = first name
row 3 = shift info
B1 = rotation data (preceded by 96 chars)
or
tab name (preceded by date, format = mmm dd)

Thanks for any assistance, I'm picking this up as fast as I can