• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. W

    Linking to an email address

    Hi all, I have a list of contacts in column B and their respective email address in column H. In a (different) summary sheet (but in the same workbook) I would like to be able to click on a cell (which references the email) and to open the outlook email window. I have read many ways of linking...
  2. W

    Reference a TIME formatted cell from a TEXT formatted cell

    Old Chippy you are a star! Having gone 'round the houses this little conundrum was driving me potty Absolutely stunning. I thank you :)
  3. W

    Reference a TIME formatted cell from a TEXT formatted cell

    I have prepared a teacher timetable as a spreadsheet and now want to present the nitty gritty in a plain English way. My hours worked cells are all formatted to custom [h]:mm but the plain English text cells are formatted to text(!) Problem: When I reference the cell ="Teacher name works...
  4. W

    Dynamic timetable formula

    Just thought.... The attached file contains all the worksheets. I am interested in getting data into the 'school TT' sheet from SctRefData Cheers
  5. W

    Dynamic timetable formula

    Thanks, Here's the file: https://dl.dropbox.com/u/67525351/Timetable%202013-2014%20GT5.xls G
  6. W

    Dynamic timetable formula

    Hi, I'm working a timetable for instrumental teaching staff, and whilst I can pull relevant data from seperate sheets to give a staff timetable (on a preformatted sheet), I'm struggling to get a SCHOOL timetable (of services WE supply. The raw data sheet contains the following columns: A...
Back
Top