Move row to another tab if any cell = Closed

July 26, 2019 at 09:26:36
Specs: Windows 10
I know there is a macro that would work for this but I cannot figure it out.

I would like to move the entire row if any cell in columns I through N contains the word "Closed".

The origin tab is named "Active" and the destination tab is named "Closed"

Any help is greatly appreciated! Thanks!

See More: Move row to another tab if any cell = Closed

Reply ↓  Report •

July 26, 2019 at 10:18:33
Is this to be done via a "scan" i.e. run the macro and have it move all Closed rows (sort of like a "clean-up" project) or do you want the rows to move as soon as Closed in entered in Column I, perhaps via a drop down?

The more specifics you can provide as to your needs, the better the chance that we can avoid a lot of back and forth and extra work.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

Reply ↓  Report •
Related Solutions

Ask Question