Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pulling data into a month of worksheets, two tabs per day
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling data from multiple worksheets | Excel Discussion (Misc queries) | |||
Pulling Data from External Worksheets | Excel Worksheet Functions | |||
formulas pulling data from other worksheets | Excel Discussion (Misc queries) | |||
pulling data into a master sheet from multiple worksheets | Excel Worksheet Functions | |||
Macro pulling data from 2 worksheets | Excel Discussion (Misc queries) |