Hi All,
I've been reading quite a bit and I'm not sure which is the best way to approach this whether there is an excel formula that can achieve what I want or if it will be a vba macro.
What I have: A "PROGRAM" spreadsheet that shows names of employees with their high risk work licences and when the licences are expiring.
What I need: To transfer rows that have an expired date to another sheet within the workbook - so that I can get a compressed list of who has expired licences.
So if I have John Smith with any "expired" date against his licence class his Surname, first name, licence number, expiry date and licence class would be transferred into the "EXPIRED" worksheet.
I also have conditional formatting applied.
Sorry I would post an example of the workbook but I can't seem to find the "attach" icon.
Please Help - any guidance is greatly appreciated.
Thanks again.
Mandii
<colgroup><col span="2"><col><col span="3"><col span="2"></colgroup><tbody>
</tbody>
I've been reading quite a bit and I'm not sure which is the best way to approach this whether there is an excel formula that can achieve what I want or if it will be a vba macro.
What I have: A "PROGRAM" spreadsheet that shows names of employees with their high risk work licences and when the licences are expiring.
What I need: To transfer rows that have an expired date to another sheet within the workbook - so that I can get a compressed list of who has expired licences.
So if I have John Smith with any "expired" date against his licence class his Surname, first name, licence number, expiry date and licence class would be transferred into the "EXPIRED" worksheet.
I also have conditional formatting applied.
Sorry I would post an example of the workbook but I can't seem to find the "attach" icon.
Please Help - any guidance is greatly appreciated.
Thanks again.
Mandii
SURNAME | FIRST NAME | LICENCE NUMBER | FORKLIFT TRUCK | SCAFFOLDING | |||
LF | LO | SB | |||||
SMITH | John | 1234567 | 28/05/2016 | ||||
BLOGGS | Joe | 0003060041 | 13/01/2020 | 13/01/2020 | |||
WHO | Damien | TBA | 18/05/2021 | 11/08/2016 | |||
SMITHE | Taylor | 0003306329 | 20/01/2020 | ||||
DOE | Jane | 0003176316 | 11/05/2017 | 15/07/2016 | |||
<colgroup><col span="2"><col><col span="3"><col span="2"></colgroup><tbody>
</tbody>