Recent content by waladd

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...

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...

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...

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...

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

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...

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.

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...

No format set.

Using color fill, so cell shading I guess?

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...