I've got a problem trying to figure out what function to use to pull the result from one sheet to another that shows:
It's sort of an IF, THEN scenario.....
IF John Jones took the Computing Security Class
THEN place a 1 in cell E8 of his personal training tracking sheet: "JONES" because it sees that he TOOK THAT CLASS in the MONTH OF JANUARY...
If he'd taken it in February - then the 1 would appear in COL F of his "JONES" tab...
If he's not taken it at all ....then zeros would appear in COL E, F and G
E,F and G of Row 12 of the JONES tab remains blank with no zeros or ones because no class name is housed in Column C to track.....
Part 2 ( posted below )
It's sort of an IF, THEN scenario.....
IF John Jones took the Computing Security Class
THEN place a 1 in cell E8 of his personal training tracking sheet: "JONES" because it sees that he TOOK THAT CLASS in the MONTH OF JANUARY...
If he'd taken it in February - then the 1 would appear in COL F of his "JONES" tab...
If he's not taken it at all ....then zeros would appear in COL E, F and G
E,F and G of Row 12 of the JONES tab remains blank with no zeros or ones because no class name is housed in Column C to track.....
Book2 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | |||||||||
2 | NAME | JOHNJONES | |||||||
3 | BEMS | 12333 | |||||||
4 | DEPT | BusinessExcellence | |||||||
5 | MGR | JerryMacDonald | |||||||
6 | 1Q | ||||||||
7 | Category | CourseName | Course# | Jan | Feb | Mar | |||
8 | MANDATORY | ComputingSecurity | E1000 | 1 | 0 | 0 | |||
9 | MANDATORY | Ethics1 | E1001 | 0 | 1 | 0 | |||
10 | MANDATORY | Ethics2 | E1002 | 0 | 1 | 0 | |||
11 | MANDATORY | Ethics3 | CS100 | 0 | 0 | 0 | |||
12 | MANDATORY | ||||||||
13 | BUSINESSUNIT&LAS/R | Diversity | D1000 | ||||||
14 | BUSINESSUNIT&LAS/R | Leadership2004 | L2004 | ||||||
15 | BUSINESSUNIT&LAS/R | LaptopSecurity | L2005 | ||||||
16 | BUSINESSUNIT&LAS/R | ||||||||
17 | BUSINESSUNIT&LAS/R | ||||||||
18 | BUSINESSUNIT&LAS/R | ||||||||
19 | BUSINESSUNIT&LAS/R | ||||||||
JONES |
Part 2 ( posted below )