Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by waladd

  1. waladd

    Spreadsheet reference help

    if you don't mind, how does it work. I pasted it into a blank cell and it showed me the name of that spreadsheet (tab). I take it I replace the file name (big leap there), after that I'm a little foggy. Should this be entered in the place of [ANCILLARY 2007.xls]0225-0310 in the formulae, or is...
  2. waladd

    Spreadsheet reference help

    the value is the name of the sheet tab, 0225-0310, 0311-0325, etc for each two week period. [ANCILLARY 2007.xls]0225-0310, the 0225-0310 is the tab for the next 2 weeks. The main problem I have is, I have to work with the way the HR person has set up her sheet, I cannot add any macros or...
  3. waladd

    Spreadsheet reference help

    I have one file for the year, I have a new tab for every two week period. This is how HR set up their Book. Hence all the colors, they have a key to tell them where someone is working or if they're sick. I've got seventeen people that I do the schedule for. I know it probably seems a little dumb...
  4. waladd

    Spreadsheet reference help

    I've been working on a work schedule for which one spreadsheet references another. Is there anyway to get the spreadsheet/cell info to auto-update. I have to do the schedule in a two week format. The formula I'm using (Thanks again Skip) is as follows: =IF(WhatInteriorColor('[ANCILLARY...
  5. waladd

    Trying to use an IF formula w/ Colored Cell

    Perfect Thank You SOOOO Much. [2thumbsup] :-D
  6. waladd

    Trying to use an IF formula w/ Colored Cell

    Tried this: =WhatInteriorColor('[ANCILLARY 2007.xls]0211-0224'!$F$7)*IF('[ANCILLARY 2007.xls]0211-0224'!$F$7="Rose","L",IF('[ANCILLARY 2007.xls]0211-0224'!$F$7="Light Yellow","ON",IF('[ANCILLARY 2007.xls]0211-0224'!$F$7="Red","SICK",IF('[ANCILLARY 2007.xls]0211-0224'!$F$7="Light...
  7. waladd

    Trying to use an IF formula w/ Colored Cell

    ok, only need to know if I can do things such as IF "Rose" then "L", if "Light Yellow" then "ON". I appreciate this so much, thank you.
  8. waladd

    Trying to use an IF formula w/ Colored Cell

    I'm trying to create a formula that reads the cell background color and reports a specific answer for that cell. My Human Resources department needs the employee schedule one way, while my employees are use to looking at it in a totally different format. HR uses a color key to code whether...
  9. waladd

    Trying to use an IF formula w/ Colored Cell

    No format set.
  10. waladd

    Trying to use an IF formula w/ Colored Cell

    Using color fill, so cell shading I guess?
  11. waladd

    Trying to use an IF formula w/ Colored Cell

    I'm trying to create a formula that reads the cell background color and reports a specific answer for that cell. My Human Resources department needs the employee schedule one way, while my employees are use to looking at it in a totally different format. HR uses a color key to code whether...
See more

Part and Inventory Search

Back
Top