There's nothing built into excel that lets you do this.

If it's possible, can you paste to the bottom of the list, then sort the list?

Steiner wrote:

I am working on a template which evaluates all the markets in which we do
business in. I have information on the some of the markets but not all of
them so i have filtered by NonBlanks so display all of the valid information.
I now have found new information on the countries that have NonBlank and
would like to paste them to my sheet as they are in the same order of my
filtered template. However, when I paste the information it disregards the
filter and pastes it on the sheet containing all the data. Naturally, the
information is not pasted in the right cells. I have gotten around it by
copying the filtered template into a new sheet however now i would like to
populate my original template but I am encountering the same problem. I
hope that this is clear. Thank you very much in advance,
laurent

--

Dave Peterson