I am desperate for help and am far out into the deep end without my water-wings.
I have a schedule that is in a long form and need to generate a daily post-able schedule from that, with a pre-designated layout, which I cannot change. I cannot restructure either sheet, as doing so is well above my pay-grade. I have been given a 'Make it work" assignment, and am drowning.
Sheet1 has the names in one column, and the full schedule for the month laid out to the right, each column being a day of the month, and the cell values being the work area assigned that day. The values-0p90 entered into Sheet 1 daily columns are values 1-6, L (Lead), and D_1-6/1-6 (For double shifts assigned, the _ being replaced with an E, N, or A, depending on the normal shift worked by the person and the second shift they will be working.)
I need to pull the names from Sheet1 (Entire Month) into cells in sheet2 (Daily printed schedule), based on the values in the day assignment columns to the right of the names on Sheet1.
On Sheet2 I have a column that lists the designated work areas. I need to pull the name for the person scheduled for that area into Sheet2, based on what they are assigned on Sheet1 for that day, based on which column to look at as selected via a Cell on Sheet2, such as Day3 or just 3, which corresponds to the day# of the column on Sheet1 that needs to be looked at to pull the names from the static name column on Sheet1.
I was able to determine the correct column number, using a MATCH(), but don’t know to do the rest of the manipulation/lookups needed to pull what I need. ALL suggestions are welcomed and appreciated
Note: Due to security setups, I cannot use Macro’s for this, it has to be done with some kind of formula, even if that is pulled into another cell set and then repopulated into where I need. I can have hidden sheets and cells. Hope that helps.Schedule_V1_scrubbed.ods