G
Guest
Hi (me again)
I'm sorting all my problems out today.
I have 120 groups, they have all been traffic lighted against 20 indicators.
I now have 1 workbook with 121 sheets in - on each sheet is a single
practice, with thier 20 indicators in column A and thier performance in
colmun B cloured Red, Amber or Green. (also behind these colours are the
numbers 1, 2 or 3
On sheet 1 I have all 20 indictors listed (column A) and Comments for Red
(column B) Amber (column C) and Green (column D)
How can I make each sheet look at the first sheet and if there's a 1 (Red)
in column B enter the corresponding red comment from sheet 1 in Column C and
so on for 2(Amber) or 3 (Green)
I've only ever used IF in the 'if its greater than enter 1 otherwise 0
senario so not sure if its possible for this sort of thing.
All help appreciated
determined UK AKA Mazzeree
Please help
I'm sorting all my problems out today.
I have 120 groups, they have all been traffic lighted against 20 indicators.
I now have 1 workbook with 121 sheets in - on each sheet is a single
practice, with thier 20 indicators in column A and thier performance in
colmun B cloured Red, Amber or Green. (also behind these colours are the
numbers 1, 2 or 3
On sheet 1 I have all 20 indictors listed (column A) and Comments for Red
(column B) Amber (column C) and Green (column D)
How can I make each sheet look at the first sheet and if there's a 1 (Red)
in column B enter the corresponding red comment from sheet 1 in Column C and
so on for 2(Amber) or 3 (Green)
I've only ever used IF in the 'if its greater than enter 1 otherwise 0
senario so not sure if its possible for this sort of thing.
All help appreciated
determined UK AKA Mazzeree
Please help