Return a value from X and Y coordinates.
Hi,
I have a planner and i am trying to populate my weekly plan from a master schedule. I have included the sheet.
I enter my class info into the class data sheet. I then use dropdown's to fill in the timetable with the required class data, in the required period. This should then populate the planner sheet as soon as the info is entered into the timetable.
In the planner i enter the day (DAY 1) and the date on monday and I want it to auto correct so that for week 1, monday, period 1 that class = 11 SCI (concatenate(timetable(B2, C2)), and room = B8 (timetable(D2))
Hopefully it is clear as mud!
Col
I cannot see the relationship from your planner to any of your other worksheets, how would you link it to other sheets?, which one(s)? what would be the changing factor that would dictate what the display on the planner would be? where would that value come from?
Your formula (if you wanted to use one) would look like this:
=CONCATENATE(Timetable!B2, Timetable!C2) & " Room " & Timetable!D2
Not all forums are the same - seek and you shall find
Thought i'd made it mud! URGH!
the timetable is a 6 day cycle, but we only have 5 in a week, so i need it to be able to lookup what the day (not date) is and then lookup the timetable using 'day' as the x and 'period' as the y value.
i need it to be able to auto fill for the rest of the term.
did that make it clearer
PS any idea how to do contitional formatting for the cell so that if it is 9sci it's yellow, if it's 12bio it's blue?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks