Excel doesn't have anything that lets you do this built into it.

But maybe you could sort your data, then paste into that contiguous range.

Then resort and reapply the filter???

C D R R wrote:

I am trying to past data from one excel workbook into another. The worksheet
that I am trying to past into uses auto filter to select just the data that I
need. When I try to paste excel pastes into all the hidden cells between
those that are shown. Is is possible to past only into those that are on show.

Thanks for any help that you can give.

--

Dave Peterson