Moving Rows based on cell content

I'm not exactly sure what you are asking so I took a stab at it.
I also cleaned up your variables a little bit. When you know what something is going to be you should declare it as such, other wise everything is variants and that's not good coding.

Please Login or Register  to view this content.

Here's a sample workbook I created. Look at it and see what it does and maybe you'll figure out what is different with yours and be able to fix it.
You can post your workbook also and tell me what you want to do and I'll help you.

Another option:

Please Login or Register  to view this content.

Red indicates criteria's 1 and 2

BTW - Code in Post#2 works for me.

Hi Bill,
The issue is that the term you are searching for is "hire" and your sheet has "HIRE". It's case sensitive, Excel doesn't see those two as the same word.

There's a few things we can do. If you want it to match the word HIRE and not the lower case hire, you can change the word in the code to all upper case, so just change the word in your code to "HIRE".

Another way is to use LCASE or UCASE. Excel uses LCASE to convert whatever string you feed it to all lower case letters. The way I'm using it the change is only made in memory, the results on your sheet will stay they way they are, upper case on sheet "EE". UCASE converts whatever string you feed it to all upper case letters.

So if I simply want to match the word "hire" and I want the match to happen without regard to case I can use either LCASE to convert whatever is in your sheet to all lower case and search for the word "hire" or I can use UCASE to convert to all upper case and search for the word "HIRE".

I chose the LCASE version for demonstration purposes.

Please Login or Register  to view this content.

What is it you want to do?
Change the criteria to 43A or 43C and hire?

It already moves 43A and hire to sheet EE

and

Move 43C and hire to sheet FE Set f = Sheets("FE")

Two separate sheets and move depending on E and G contents

Thanks