Moving rows to another sheet based on a certain field's value

**siourisc** · 09-26-2012, 01:46 PM

Hi All, New poster and I have very little experience with VBA/Macros. As the title states I would like to move an entire row of data to a new sheet based on a certain fields value. This certain fields value will be generated using V-Lookup. Attached is my Spreadsheet. I am using Excel 2007.

I am using Vlookup to compare EE SS numbers. If their is not a match I would like to pull that row to the new sheet, "Sheet 2".

For example on the spreadsheet since ee SS #'s 8754, 5390, and 7071 do not have a match, I would like those copied to Sheet 2.

If someone believes their is a better strategy than VLookup and Array Formulas please let me know. Thanks in advance.

**arlu1201** · 09-27-2012, 04:14 AM

Do you want the movement of rows to happen on the click of a button?

Do you want the row that is being copied / moved to be deleted from the original sheet?

**siourisc** · 09-27-2012, 01:59 PM

A button is not necessary. I have no problem just running the macro once the spreadsheets have been populated. I would like the row to be copied to remain on the original sheet.

Thanks for the response Arlu.