Automatic means VBA code.

See Ron de Bruin's site for copying filtered results.

http://www.rondebruin.nl/copy5.htm


Gord Dibben MS Excel MVP

On Tue, 4 May 2010 11:32:01 -0700, jpstormy
wrote:

Can I copy a worksheet so that the new worksheet looks exactly like the
visible portion of the old worksheet. For example, if I filter and sort, I
only want what is left visible to appear in my new worksheet, and I want it
to do it automatically without my having to copy and paste.