Macro: Copy/cut all rows matching criteria, and paste into specific Table/sheet

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Ok, attached a mock version of my workbook.

Sheets involved:

• Platter
• Finished

On sheet: 'Platter', you'll notice column B is exclusively 6-digit numbers. Every unique number has several rows and represents a formula for a batch.

I have a few macros in place that make it really easy for me to assign a batch number to a particular person by filling values into column C
As well as a couple macros to fill in a Y/N value for column N, to indicate if a batch is finished or not. Pics/Code below.

Current Macros for batches, pastebin: http://pastebin.com/HhEnZf1m

Image showing above macro buttons:
macroribbon.png

What I'm looking for:

Right now, after a batch is finished, i indicate it as Done with a macro above. But then i have to manually select the rows, cut/copy, select a cell underneath Table3 on Sheet 'Finished', and paste. Then go back to Table1 on Sheet 'Platter' and delete the old blank rows.

I'm hoping to automate the moving of a particular set of rows with the 6-digit number matching the active cell (in column B) from one table to another.

And if it's possible, i'd like only the cell values to be pasted/moved - i'd rather the formats not come too. I usually achieve this by pasting via 'Right-click cell + S V'

Hope this helps