Transfer Rows from One Worksheet to Another if Certain Condition is met

[ctbanker]

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!

 

[rayk8301]

you need to set up a macro. there wouldn't be a formula or anything that would do that to my knowledge.

 

[ctbanker]

I'm relatively new to coding so I guess I will have to try to manipulate codes from other threads