Moving data from one worksheet to another based on criteria

[dwhite30518]

Good evening everyone!!

I need some help again!

I would like to use some code that would search a worksheets within a specific column and looking for a specific keyword, then cut that record from the worksheet and paste to a predetermined worksheet within the workbook.

Does anyone have code that can accomplish this?

Thanks!!!!

[patel45]

http://www.rondebruin.nl/win/section3.htm

[mgs73]

I think this does what you ask - the function MoveRange searches for something in a specified column on one sheet, and if it finds it, it places it in a specified cell on another sheet and removes it from the first sheet.

Note: This code assumes what you are looking for appears only once in the column. Also, from your description it is not clear if the Find Method should specify LookAt:=xlWhole (search string = cell value) or xlPart (search string somewhere in cell value).

Please Login or Register  to view this content.

[JOHN H. DAVIS]

This uses Column A as the specific Column:

Please Login or Register  to view this content.