Move entire row to another worksheet based on cell value

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button.

I'm a fan of using AutoFilter to move all appropriate rows in a single pass, so this non-looping method is one I would employ. (note, your sample sheet has a lot of hidden data way down the sheet, so clear all that in columns A:G before trying this:

Please Login or Register  to view this content.

Jerry-

Thanks that worked awsome. In my acutal spreadsheet i need it to return Column (B,C,D,E,N,O) and its now returning (a,b,c,d,e,f)

see the modifications i did. can you help me return what i need when i change the range it it gives me a 400 error

Please Login or Register  to view this content.

This code works but how do i make it override the info it reported last time when I run/refresh the macro?

I want it to auto update and that add infoto the bottom when the other rows met criteria

Can anyone help with this

See code below

Please Login or Register  to view this content.

As per forum rules, please EDIT your posts above and add CODE and /CODE tags around the VBA as explained in my signature. Lots of useful tips in the FORUM RULES, read the link above.

Thought i had already done so.

Here it is

Please Login or Register  to view this content.

Maybe like so:

Please Login or Register  to view this content.

Back on post #4 we had "that works awesome" to now... what?

I'm going to have to move on. Sorry if it wasn't awesome enough. I'll ping some others to take a look. Cheers.

If that takes care of your original request, please select Thread Tools from menu above and set this topic to SOLVED.