Move and delete rows

Hi,

I am trying to create a macro the looks at column A and moves the entire row to another worksheet or deletes the entire row based off of the value in each cell. Right now I have the Macro replace the downloaded values to either AG, G, GI, ICP, IMG or delete. The idea be to move all of the values with AG in column A to the AG worksheet, move G to the G worksheet, etc.. and then delete all of those with delete in the cell. This is what I have so far, could someone help me to create this???

Please Login or Register  to view this content.

Welcome to the forum.

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

Thanks.

CODE tags, please, not PHP tags.

Thanks.

I think this does the same as your code (which you could verify).

Please Login or Register  to view this content.

Now you want to move the cells containing "GI" to sheet GI? Just individual cells or entire rows? Move them to the bottom of exsiting data?

Will that be the only text in those cells?

Try this (completely untested)O. Post a workbook if it doesn't work.

Please Login or Register  to view this content.

See attached.

Change code as shown below:

Please Login or Register  to view this content.

You're welcome. Would you please mark the thread as SOlved?