No Worksheet Activate event anymore.
1) Double click on Col.A will update all data.
2) Add/change in Col.A will update corresponding 2 cells.
3) change in Col.B is taken as new MIN and updates other same name accordingly if any.
4) change in Col.C is taken as new Max and updates other same name accordingly if any.
Bookmarks