Originally Posted by
eins
Hi Souza,
1°, 2° Code verifies, whether a cell value has been changed (for each cell from Target range).
3° Mentioned code verifies if there's an employee on the list (in col E : Cells(kom.Row, 5).Value <> "") and whether the employee has to work in more than one place (cl = Cells(kom.Row, 5).Value And cl.Row <> kom.Row). The condition : Cells(cl.Row, kom.Column) <> "" verifies, whether there is an information on employment 'E'.
I think I am not really good at explaining the code, but if you need advise about that one, please do not hesitate to send me private message.
In attached workbook when you change the information on employment (F:AJ), the summary is updating automatically (row 131 and next).
There's a kind of conditional formatting in attached workbook.
Mit freundlichen Grüßen
Eins