VBA - Select, copy, paste entire row based on criteria

[seanjon]

I have search, so forgive me if I just could not find it.

Sheet "DATA" contains all the raw data
Sheet "RATE" is where I want 'rated' jobs
Sheet "HOT" is where I want all the 'hot' jobs
Everything with an R at the end of the work center number in Column A is considered "RATED"
Everything with the word 'HOT' in column B is considered "HOT"

I need the raw data to stay on the "DATA" sheet it is on as I use it to sort data for another reason.

I need a vba code that will select all the rows with rate work centers, copy the entire row, and paste them to the sheet "RATE" and code that will select all the rows with hot jobs, copy the entire row, and paste them to the sheet "HOT"

Thanks in advance
SJ

 

[Enzo_Matrix]

I got an error on the the code:
"Run-time error '9':
Subscript out of range"

For line: "Sheets(Sht).UsedRange.Clear"

 

[Enzo_Matrix]

Nevermind. I had a slightly different sheet name that the original code. Changed it and it works great now. Thanks!

 

[Fluff]

Glad to help & thanks for the feedback