Hi Guys, Sorry if this is an easy question, I'm a VBA beginner. This is a training tracker used within our team. Is there a module that;
automatically detects cell value "Did Not Attend" in column "J" and if TRUE - inserts a duplicated row below (without the cell data of "J" & "L:S")
Many Thanks in Advance!
SO THIS....
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S |
Employee ID | Name | Job Title | Location | Budget Month | Actual Month | Expiry Date | Qualification | Trainer | Start Date | Finish Date if different | Month | Start Time | Finish Time | Venue | ||||
2017 Budget | Essential | Initial | DAV | Gavin Davies | Operative | NYC | Asbestos Awareness | Pearson Vue | 1 | May | 08:03 | 09:03 | Bolty | |||||
2017 Budget | Essential | Renewal | DAV | Gavin D | Operative | NYC | Did not attend | 07/09/2017 | National Water Hygiene Scheme | Pearson Vue | 2 | June | 08:02 | 09:02 | Bolty | |||
2017 Budget | Essential | Renewal | DAV | Gavin D | Operative | NYC | 07/09/2017 | National Water Hygiene Scheme | Pearson Vue | 3 | July | 08:01 | 09:01 | Bolty | ||||
2017 Budget | Essential | Initial | DAV | Gavin D | Operative | NYC | Working at Heights | Pearson Vue | 4 | August | 08:00 | 09:00 | Bolty | |||||
2017 Budget | Essential | Initial | DAV | Gavin D | Operative | NYC | March | Confined Space Entry - City & Guilds | Ronnie Traiing | 9 | July | 08:28 | 17:02 | Skellon | ||||
Health and Safety Test | Essential | Initial | M_MUL | Gavin Mui | Estimator | WA | Health and Safety test | Ronnie Traiing | 10 | August | 08:29 | 17:01 | Skellon | |||||
2017 Budget | Essential | Initial | M_MUL | Gavin Mui | Estimator | WA | June | Temporary Works Coordinator | Ronnie Traiing | 11 | September | 08:30 | 17:00 | Skellon | ||||
2017 Budget | Essential | Initial | M_MUL | Gavin Mui | Estimator | WA | CANDY | Pearson Vue | 2 | June | 08:02 | 09:02 | Bolty | |||||
2017 Budget | Essential | Initial | M_MUL | Gavin Mui | Estimator | WA | CSCS card | Pearson Vue | 3 | July | 08:01 | 09:01 | Bolty | |||||
BECOMES... | ||||||||||||||||||
Employee ID | Name | Job Title | Location | Budget Month | Actual Month | Expiry Date | Qualification | Trainer | Start Date | Finish Date if different | Month | Start Time | Finish Time | Venue | ||||
2017 Budget | Essential | Initial | DAV | Gavin Davies | Operative | NYC | Asbestos Awareness | Pearson Vue | 1 | May | 08:03 | 09:03 | Bolty | |||||
2017 Budget | Essential | Renewal | DAV | Gavin D | Operative | NYC | Did not attend | 07/09/2017 | National Water Hygiene Scheme | Pearson Vue | 2 | June | 08:02 | 09:02 | Bolty | |||
2017 Budget | Essential | Renewal | DAV | Gavin D | Operative | NYC | 07/09/2017 | National Water Hygiene Scheme | ||||||||||
2017 Budget | Essential | Renewal | DAV | Gavin D | Operative | NYC | 07/09/2017 | National Water Hygiene Scheme | Pearson Vue | 4 | August | 08:00 | 09:00 | Bolty | ||||
2017 Budget | Essential | Initial | DAV | Gavin D | Operative | NYC | Working at Heights | Ronnie Traiing | 9 | July | 08:28 | 17:02 | Skellon | |||||
2017 Budget | Essential | Initial | DAV | Gavin D | Operative | NYC | March | Confined Space Entry - City & Guilds | Ronnie Traiing | 10 | August | 08:29 | 17:01 | Skellon | ||||
Health and Safety Test | Essential | Initial | M_MUL | Gavin Mui | Estimator | WA | Health and Safety test | Ronnie Traiing | 11 | September | 08:30 | 17:00 | Skellon |
<tbody>
</tbody><colgroup><col><col span="2"><col><col><col><col><col><col><col><col><col><col><col span="4"><col><col></colgroup>