Hi All,
I want to transfer certain rows from one worksheet to another if for example, column T = "Complete". I have a bunch of columns listing out tasks, and when the task is complete, users input "Complete" in column T. And I need it in set-up in a way where it cuts it from one worksheet and pastes it in the other (and if this is possible, will the original worksheet's cells automatically shift up after a row has been cut??). Not simply copy and pasted. I couldn't find a thread to do something like so any help would be appreciated.
Is there an easy to code this?
Thanks!
I want to transfer certain rows from one worksheet to another if for example, column T = "Complete". I have a bunch of columns listing out tasks, and when the task is complete, users input "Complete" in column T. And I need it in set-up in a way where it cuts it from one worksheet and pastes it in the other (and if this is possible, will the original worksheet's cells automatically shift up after a row has been cut??). Not simply copy and pasted. I couldn't find a thread to do something like so any help would be appreciated.
Is there an easy to code this?
Thanks!