How to paste data from one excel into another filtered excel

If your content isn't a formula, I'll do it again:

Suppose the ** of the filter is called sheet1 (no, just change it, or change the formula behind me), and the filter is in column d.

To another ** (i.e. the ** that is ready to be replicated, assuming the area that is ready to be replicated is in column C), point cell H1, insert, name, and enter at the name.

abc, enter in the box below.

sheet1!d1), OK. Then enter it in h1.

abc, the formula is copied to, for example, h999.

Enter it in g1.

if(h1=0,sheet1!d1, c1), the formula is replicated. Select the data, right-click, copy, d1 to sheet1, right-click, paste specially, data. That's it.

Inserting that name returns the row height of the sheet1d column, which is 0 if it is filtered and hidden. The following if formula means that if the row height is 0, that value is referenced, and if it is not 0 (not filtered out), the value that is ready to be copied is referenced.

Of course, it can also be implemented with VB, but I think the formula is better understood.

Filter the data first.

Then select the filtered data and click on the toolbar.

Positioning. Then click on the bottom left corner.

The targeting dialog box pops up.

Click in the Targeting dialog box.

Visible cells.

Options. Confirm to exit. At this point, only the filtered data remains. Then press Ctrl+C to copy, and go to the place where you need to paste Ctrl+V to paste.

Select the area you want to copy ---F5--- targeting --- visible cells.

Then copy again.

1. Open Excel**, select the options that need to be filtered in **, and filter the number "1" in the figure below.

2. The number "1" can be filtered out in the cell.

3. Then click on the "Find" option in the toolbar and select the "Positioning" option in the drop-down box.

4. Select "Courseware Cell" in the pop-up "Positioning" dialog box and click "Positioning".

5. You can select the filtered cells in column A and copy the cells.

6. Click to New Filter**, right-click, and select "Paste Value to Visible Cell".

7. You can complete the operation of pasting to the new filter**.

1. First of all, open the filtered data excel** on the computer, here to copy the data in the sheet1 worksheet to the sheet2 worksheet as an example.

2. Then, click on the data menu column in the top toolbar.

3. Then, find the advanced option under the open data menu column, and click to open the advanced option.

<>5. Finally, select the list area, the condition area and the copied location in the small window of advanced filtering, and then click the OK button.

1. Take Excel2010 version as an example, as shown in the figure below, the filtered data should be copied to another table at one time;

2. Select one of the data first, then press Ctrl+A to select all the filtered data, and then press Ctrl+C to copy;

3. After copying, open another table, press Ctrl+V in the place you want to copy, and then you can copy the filtered data to this table at one time.

1. First of all, open Excel**, and the data cells have been filtered in **.

2. Then select the cells that need to be copied and pasted in another Excel** and press Ctrl+C to copy the operation.

3. Then select the cell range you need to paste and click "Find & Select" in the toolbar to select "Positioning".

4. You can locate the selected cell area.

5. At this time, press Ctrl+V or right-click the mouse button to select Paste Value to paste the copied data into the visible cell.

Cause: The filtered data cells are not copied after the "visible cells" are located.

Solution: 1. First filter the data in Excel**, for example, filter the number "1".

2. Then select the cells that have been filtered by Xuntype, and click the "Positioning" option under the "Find" column in the toolbar.

3. Then select "Visible Cell" in the "Positioning" dialog box that opens, and click Positioning.

4. You can locate the visible cells and press "CTRL+C" to copy them.

5. Then right-click the position of the first square of the single orange Chang that needs to be pasted, and click to paste as a value.

6. You can paste the copied filtered data sticky circle number into the blank cell.

1. For example, the ** data in the figure below, this is the filtered data, and next, the data of Xiangnai should be copied out.

2. Copy these data, we can't just select the data and press Ctrl+C, and then press Ctrl+V, and paste it quietly. Here's what we need to do: Select ** first. Press Ctrl+G again to bring up the location dialog.

3. In the dialog box, click again: Positioning conditions.

4. Open the dialog box of the positioning conditions, and then click to see the Jinyunchun cell, and then click OK.

5. At this time, we press CTRL+C again to copy. Then, click in another empty cell, press Ctrl+V, and paste the data.