Excel2013 copy content into a brushed data table

How to paste the copied content into the filtered table:

1, need a form; I'm going to change the Name column in this table to the data column in the other table;

2. Insert two columns to the right of the name, column A, column B;

3, in column a the first grid input 1, down sequence filled;

4, filter out the class does not contain a, select column B below the cell, press ALT +, enter 1 after pressing Ctrl+enter (equivalent to the visible cell fill), cancel the filter;

5, sorted by column B, column B contains 1 of the cells are arranged on the top of the list; Select what you want to replace, copy and paste to the Name column, and finally sort by column A, delete column A, column B, and then return to the original, OK.

Excel2013 copy content into a brushed data table