Removing Rows based upon Criteria in Cells

I have a worksheet where I need to look for several employees names that are "exempt" and I need to delete those rows out and add them to a different sheet.
I was wondering if it is possible to have a macro look at the names in column A in worksheet "Exempt List" (which the list can contain as few as 1 or as many as 150 employees), and cut the rows that have those names in the "ReportExcel" column G. The same names will be listed several times, typically once per week and then Paste those Rows in the "Exempt" worksheet.

Any thoughts would be appreciated,

Hi
not sure whether you identify exempt people from column A or Column G. This macro assumes column A - change to G if that's where the names are. it also assumes a column heading in row 1, so doesn't move text from that row

Please Login or Register  to view this content.

It appears this is just cutting the names from the Exempt list and transferring it to the Exempt worksheet, what needs to happen is the entire rows that match a name in column A in "Exempt" in column G in "ReportExcel"...that row in the worksheet "ReportExcel" needs to be cut out and transferred to the "Exempt" worksheet. the "Example" worksheet shows what should happen.

yes that is what I mean, its kind of hard to say...
there is a file in the original thread, with an example of all the data...
also it is important that the integrity (or formatting) of the "reportexcel" worksheet should look as if those rows never existed...
I appreciate your assistance

The data needs entered starting in cell A2 of the "Exempt" worksheet as there will be a header row just like in the "ReportExcel" worksheet. I have attached another file in a different format for users with 2007 or 2010 version. Any guidance would be appreciated.
The file is below
Exempt.xlsx

So the following code finds the items located in the column A of "Exempt List" worksheet in column G of the "ReportExcel" and copies the entire row to the "Exempt" worksheet, but the issue is it doesn't cut the info from the "ReportExcel" worksheet.

Please Login or Register  to view this content.

Any idea of what code I can enter to cut the data needed from the "ReportExcel" worksheet?

Any thoughts if I can tweak this code to cut instead of copy?

after reading hundreds of similiar threads, I found this code

Please Login or Register  to view this content.

So I know this code will not work in its current state to my worksheet, but can it be altered for my needs?

That works brilliantly for my example file, but in my real file I have data in columns A-S, how can I change this code to cut and paste the data from all the columns? I have changed the parameters every way imaginable, and nothing seems to be working for me.?.

Thank you, I really appreciate your assistance!