+ Reply to Thread
Results 1 to 3 of 3

Return a value from X and Y coordinates.

  1. #1
    Registered User
    Join Date
    07-11-2010
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    16

    Unhappy 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
    Attached Files Attached Files

  2. #2
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161

    Re: Return a value from X and Y coordinates.

    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

  3. #3
    Registered User
    Join Date
    07-11-2010
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Return a value from X and Y coordinates.

    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?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1