Hi,
Consider in a workbook, I have 3 or more sheets in date format (Jan-05-2012,Jan-06-2012,Jan-07-201 and ..)along with a summary sheet. And in every date sheet, i have two or more names (name 1, name 3 and ...). And each name has one value in a day sheet.
Day1 sheet eg:
Names -- Tasks completed -- Tasks Planned
Name 1 -- 4 -- 10
Day2 sheet eg:
Name 1 -- 16 -- 10
Day3 sheet eg:
Name 1 -- 8 -- 10
Day4 sheet eg:
Name 1 -- 12 -- 10
Summary sheet should calculate sum of all other sheets 'Tasks Planned' values for name 1 to name n.
Condition 1: if today is day 1 then the task completed should be '5' and status in summary sheet Red(TC 2/10 TP) and over all status Red. see below
Output should be
Names -- Tasks completed -- status - overall status
day 1
Name 1 -- 4 -- Red -- Red
day 2
Name 1 -- 16 -- Green -- Green
day 3
Name 1 -- 8 -- Amber - amber
day 4
Name 1 -- 12 -- Green - Green
PS: Since the sheet names and names are not consistent. so better to use formula to solve.
Consider in a workbook, I have 3 or more sheets in date format (Jan-05-2012,Jan-06-2012,Jan-07-201 and ..)along with a summary sheet. And in every date sheet, i have two or more names (name 1, name 3 and ...). And each name has one value in a day sheet.
Day1 sheet eg:
Names -- Tasks completed -- Tasks Planned
Name 1 -- 4 -- 10
Day2 sheet eg:
Name 1 -- 16 -- 10
Day3 sheet eg:
Name 1 -- 8 -- 10
Day4 sheet eg:
Name 1 -- 12 -- 10
Summary sheet should calculate sum of all other sheets 'Tasks Planned' values for name 1 to name n.
Condition 1: if today is day 1 then the task completed should be '5' and status in summary sheet Red(TC 2/10 TP) and over all status Red. see below
Output should be
Names -- Tasks completed -- status - overall status
day 1
Name 1 -- 4 -- Red -- Red
day 2
Name 1 -- 16 -- Green -- Green
day 3
Name 1 -- 8 -- Amber - amber
day 4
Name 1 -- 12 -- Green - Green
PS: Since the sheet names and names are not consistent. so better to use formula to solve.