Hi I am looking for a code that will move rows dependent on cell values.
It is technically a project tracking sheet with different project steps, ideally I would love if a code can move rows up based on column entry (completed project steps)
Project rows start at row 7 to row 500, with the first step of the project beginning on column H to P (project steps).
With each subquent step "completion" - would like to see if the rows move up automatically.
Not sure if this is possible either - would we be able to incorporate row color changes? such as dark grey if the first step is marked complete and vice versa?
Appreciate all your help in assisting me - have been watching a few videos trying to formulate a code with no luck.
Thanks in advance!!
It is technically a project tracking sheet with different project steps, ideally I would love if a code can move rows up based on column entry (completed project steps)
Project rows start at row 7 to row 500, with the first step of the project beginning on column H to P (project steps).
With each subquent step "completion" - would like to see if the rows move up automatically.
Not sure if this is possible either - would we be able to incorporate row color changes? such as dark grey if the first step is marked complete and vice versa?
Appreciate all your help in assisting me - have been watching a few videos trying to formulate a code with no luck.
Thanks in advance!!