Add row and copy some data when a cell = "value"

[dusoldk]

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

 

[bebo021999]

We can not see which column is column G? and A-D?
It is better that you can input some sample data, for "before" and "after" the code run.

 

[dusoldk]

Sorry I cut it off. I attached an example of what I would like to accomplish

Thanks

 

[dusoldk]

Any ideas on this?
Thanks in advance