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.

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.

Maybe I am making this too complicated. I have a grocery list that I put
what I need in Column A and then autofilter non-blank cells and sort by store
isle. I want this file to sync to my ipaq, but my ipaq uses pocket excel,
which does not support the autofilter. I thought if I could create a new
file that just showed what was visible in my other file, it could sync
without the autofilter. Is there an easier way to do this? Or does anyone
know how to make the autofilter sync to the pocket excel?

"Gord Dibben" wrote:

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.

.

Got it! Just undo the "convert" option on the ipaq. I did figure out how to
make it work the other way, but this was much simpler. Thanks for your time!

"jpstormy" wrote:

Maybe I am making this too complicated. I have a grocery list that I put
what I need in Column A and then autofilter non-blank cells and sort by store
isle. I want this file to sync to my ipaq, but my ipaq uses pocket excel,
which does not support the autofilter. I thought if I could create a new
file that just showed what was visible in my other file, it could sync
without the autofilter. Is there an easier way to do this? Or does anyone
know how to make the autofilter sync to the pocket excel?

"Gord Dibben" wrote:

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.

.