I created the worksheet below to keep track of actions on a project punchlist. What I want to do is if column G is set to "New Task" I want to add a line under that line, copying column A - D. If it is set to "Closed" I want that line (and all associated lines above) to close and shade all cells.
No. | Open Date | Opened By | Item Description | Current Action Item Holder | Current Action Item | Closed or New Action |
1 | ||||||
2 | ||||||
3 | ||||||
4 | ||||||
5 | ||||||
6 | ||||||
7 |