Macro to Cut out a row and move to new sheet

[ldurham]

I'm in need of a macro that will cut a row out of a worksheet based on a criteria in a specific column, and add to a new sheet ( need to keep history, but dont want it on the main report), I've attached a sample.
THANK YOU in advance, I'm in desperate need of this and can't figure it out.

[Mumps1]

Copy and paste this macro into the worksheet code module. Do the following: right click the tab for your main sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet.

Please Login or Register  to view this content.

When you enter "NLT" in column AA, the row will be cut to the other sheet.

[MarvinP]

Hi Idurham,

Here is the code to do what you want. Right click on your button and have it execute this code:

Please Login or Register  to view this content.

[ldurham]

OH MY !! this is awesome !! THANK YOU !!!

I also need an "on close" remove all filters..
I'm working on that now , but can't seem to get that to work..
Can you help?

[JOHN H. DAVIS]

If you want to remove filters when changing from the activesheet then:

Please Login or Register  to view this content.

[ldurham]

that is awesome and I will hang on to this for future.. but I don't really want the filters to go away, ( my bad, I wasn't clear on the request .... just reset back to "show all " when the workbook is closed.
THANK YOU !

[jackf-nc]

Hey guys i attempted to use your solution for my needs it works great to a degree. Using OP sample if I just wanted certain cells corresponding to nlt row (for ex if I wanted nlt names (sheet3 f7 and f8 - caesar and cheryl), would like a couple other cells related on same row pasted to other sheet (nlt) Bottom line I dont want entire row. Make sense?

Thanks,
Jack