Autofilter Pasting

merchantmarine

New Member
Joined
Dec 8, 2002
Messages
20
I copy rows from Sheet 1 and want to paste to Sheet 2.

Sheet 2 is autofiltered and I only want to paste to those rows that are shown and meet my filtered criteria.

How can I do this and not paste to those rows that have been filtered out?

Thanks.
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
Hi:

When copying and pasting (filtered items) from a filtered list to another sheet or range you should be able to only copy the cells of interest.

When coping cells to a filtered list you would need to redefine the auto filter range to then include the additional items added.

I appologize if I misunderstood your question. Please clarify with a short example.

plettieri
 

merchantmarine

New Member
Joined
Dec 8, 2002
Messages
20
sheet 1 is unfiltered, so I copy rows 1 ~ 10.
Sheet 2 is filtered, so let's say only the odd numbered rows are shown.

I want to paste rows 1-10 of Sheet 1 to only the odd numbers rows of Sheet 2. So after pasting, the even numbers of Sheet 2 should stay blank.

So it should look like this when done

SHEET 2
Rows Column A
1 A
2
3
4
 

merchantmarine

New Member
Joined
Dec 8, 2002
Messages
20
Sorry, accidently submitted reply before I was done...so ignore my last part if confusing to you. Thanks.
 

merchantmarine

New Member
Joined
Dec 8, 2002
Messages
20
So basically when I paste to filtered column, my copied data is also pasting to the 'invisible' rows. I only want the data to paste to the 'visible' filtered rows.
 

Forum statistics

Threads
1,136,423
Messages
5,675,765
Members
419,585
Latest member
popsin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top